Collections:
Rename a Tablespace in Oracle
How To Rename a Tablespace in Oracle?
✍: FYIcenter.com
You can easily rename a tablespace by using the ALTER TABLESPACE ... RENAME TO statement as shown in the example below:
SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL> ALTER TABLESPACE my_space RENAME TO your_space; Tablespace created. SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS 2 FROM USER_TABLESPACES; TABLESPACE_NAME STATUS CONTENTS ---------------- --------------- --------- SYSTEM ONLINE PERMANENT UNDO ONLINE UNDO SYSAUX ONLINE PERMANENT TEMP ONLINE TEMPORARY USERS ONLINE PERMANENT YOUR_SPACE ONLINE PERMANENT
⇐ Create a New Tablespace in Oracle
2019-04-13, 2074🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was p...