create temporary tablespace temp2 tempfile '$ORACLE_HOME\oradata\orcl\temp02.dbf' size 100m autoextend on;
alter database default temporary tablespace temp2;
drop tablespace temp including contents and datafiles;
[url]
http://www.dbspecialists.com/files/presentations/temp_space.html[/url]
alter database default temporary tablespace temp2;
drop tablespace temp including contents and datafiles;
[url]
http://www.dbspecialists.com/files/presentations/temp_space.html[/url]