oracle临时表空间过大的解决办法

create temporary tablespace temp2
 tempfile  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEMP02.DBF' size 512M reuse
 autoextend on next 640k maxsize unlimited;
 
 alter database default temporary tablespace temp2;
 
 drop tablespace temp including contents and datafiles;
 
 create temporary tablespace temp
 tempfile  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEMP01.DBF' size 512M reuse
autoextend on next 640K maxsize unlimited;

alter database default temporary tablespace temp;
 

 
 drop tablespace temp2 including contents and datafiles;