Friday 10 January 2014

How To Create a New Tablespace?

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>

No comments:

Post a Comment