How to create tablespace in oracle
Use the CREATE TABLESPACE statement to create a tablespace, which is an allocation of space in the database that can contain schema objects
SYS@dev12c )SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_DATA_FILES
2 ORDER BY TABLESPACE_NAME;
TABLESPACE_NAME FILE_NAME
EXAMPLE /u01/app/oracle/oradata/dev12c/example01.dbf
MY_DATA /u01/app/oracle/oradata/dev12c/my_data01.dbf
SYSAUX /u01/app/oracle/oradata/dev12c/sysaux01.dbf
SYSTEM /u01/app/oracle/oradata/dev12c/system01.dbf
UNDOTBS1 /u01/app/oracle/oradata/dev12c/undotbs01.dbf
USERS /u01/app/oracle/oradata/dev12c/users01.dbf
6 rows selected.