IN ORACLE MILIEU …

Oracle 9i: SQL> CREATE TABLESPACE test1 DATAFILE ‘/u01/app/orsbox/proddata/test1.dbf’ size 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. For Renaming the tablespace, we don’t have a direct command in 9i. For that we need to follow the below steps. 1) Export all of the objects from the tablespace [orsbox@ocvmrh2124 9.2.0]$ exp system/manager FILE=test1.dmp LOG=test1.log [...]