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>
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