CREATE tablespace TEMP2 datafile '/data1/ora9data/temp2_01.dbf' size 100k TEMPORARY;
Tablespace created.
ALTER DATABASE DEFAULT TEMPORARY tablespace TEMP2;
Database altered.
DROP tablespace temp including contents AND datafiles;
Tablespace dropped.
CREATE tablespace TEMP2 datafile '/data1/ora9data/temp2_01.dbf' size 100k TEMPORARY;
Tablespace created.
ALTER DATABASE DEFAULT TEMPORARY tablespace TEMP2;
Database altered.
DROP tablespace temp including contents AND datafiles;
Tablespace dropped.