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, 1650🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...