更换临时表空间TEMP

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