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.