Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Rename a Tablespace
How To Rename a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files
✍: 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
2007-05-03, 4650👍, 0💬
Popular Posts:
What are the different elements in Functions points? The different elements in function points are a...
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To ...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
what are the advantages of hosting WCF Services in IIS as compared to self hosting? There are two ma...