Friday 10 January 2014

How To Rename a Tablespace?

SQL> CREATE TABLESPACE tbs DATAFILE '/d01/oracle/oradata/prod/tbs.dbf' SIZE 10M;

Tablespace created.

SQL> alter tablespace tbs rename to mytbs;

Tablespace altered.

SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM DBA_TABLESPACES;

TABLESPACE_NAME           STATUS    CONTENTS
------------------------- --------- ---------
SYSTEM                    ONLINE    PERMANENT
SYSAUX                    ONLINE    PERMANENT
UNDOTBS1                  ONLINE    UNDO
TEMP                      ONLINE    TEMPORARY
USERS                     ONLINE    PERMANENT
EXAMPLE                   ONLINE    PERMANENT
ABDULWASIQ                ONLINE    PERMANENT
MYTBS                     ONLINE    PERMANENT

8 rows selected.

SQL>


No comments:

Post a Comment