oracle 临时表空间过大 清除

CREATE TEMPORARY TABLESPACE temp2
TEMPFILE 'C:\APP\THINKPAD\ORADATA\ORCL\TEMP02.DBF' SIZE 5M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;



CREATE TEMPORARY TABLESPACE temp
TEMPFILE 'C:\APP\THINKPAD\ORADATA\ORCL\TEMP01.DBF' SIZE 256M REUSE
AUTOEXTEND ON NEXT 128M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;


DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;