SQL>CREATE TABLESPACE abdulwasiq DATAFILE '/d01/oracle/oradata/prod/abdulwasiq.dbf' SIZE 10M;
Tablespace created.
SQL> SELECT TABLESPACE_NAME,file_name from dba_data_files;
TABLESPACE_NAME FILE_NAME
------------------------- -----------------------------------------------------------------------------------
USERS /d01/oracle/oradata/prod/users01.dbf
UNDOTBS1 /d01/oracle/oradata/prod/undotbs01.dbf
SYSAUX /d01/oracle/oradata/prod/sysaux01.dbf
SYSTEM /d01/oracle/oradata/prod/system01.dbf
USERS /d01/oracle/oradata/prod/users02.dbf
EXAMPLE /d01/oracle/oradata/prod/example01.dbf
ABDULWASIQ /d01/oracle/oradata/prod/abdulwasiq.dbf
7 rows selected.
SQL>
Tablespace created.
TABLESPACE_NAME FILE_NAME
------------------------- -----------------------------------------------------------------------------------
USERS /d01/oracle/oradata/prod/users01.dbf
UNDOTBS1 /d01/oracle/oradata/prod/undotbs01.dbf
SYSAUX /d01/oracle/oradata/prod/sysaux01.dbf
SYSTEM /d01/oracle/oradata/prod/system01.dbf
USERS /d01/oracle/oradata/prod/users02.dbf
EXAMPLE /d01/oracle/oradata/prod/example01.dbf
ABDULWASIQ /d01/oracle/oradata/prod/abdulwasiq.dbf
7 rows selected.
SQL>
No comments:
Post a Comment