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, 1731🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...