create temporary tablespace t1
tempfile '/u01/g/t1.dbf'
size 512M reuse autoextend on next 10M maxsize unlimited
extent management local uniform size 256K;

select property_value from database_properties
where property_name='DEFAULT_TEMP_TABLESPACE';

alter database default temporary tablespace t1;

drop tablespace temp including contents and datafiles;

alter database
tempfile '/u02/oradata/grussell/t1.dbf'
ONLINE;


create temporary tablespace temp
tempfile '/u02/oradata/grussell/temp01.dbf'
size 512M reuse autoextend on next 10M maxsize 4096M
extent management local uniform size 256K;

alter database default temporary tablespace temp;

drop tablespace t1 including contents and datafiles;

alter database
tempfile '/u02/oradata/grussell/temp01.dbf'
ONLINE;