SQL>

SQL> create temporary tablespace temp2 tempfile '/URP/oracle/oradata/urpjw/temp001.dbf' size 170M;

Tablespace created

SQL> alter database default temporary tablespace temp2;

Database altered

SQL> drop tablespace temp

2 ;

Tablespace dropped

SQL>

SQL>

SQL>

SQL>

SQL> create temporary tablespace temp tempfile '/URP/oracle/oradata/urpjw/temp01.dbf' size 1024M;

Tablespace created

SQL> alter database default temporary tablespace temp;

Database altered

SQL> drop tablespace temp2;

Tablespace dropped