To create Temporary Tablespace
CREATE TEMPORARY TABLESPACE TEMPORAL1 TEMPFILE
'+DATA_SCUKOFE_SVC' SIZE 2g AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;
To set up as default
alter database default temporary tablespace temporal1;
To drop tablespace temporary
drop tablespace TEMP including contents and datafiles;
