1.创建中转临时表空间
create temporary tablespace TEMP1 TEMPFILE ‘/data/dbfile/temp_02.dbf’ SIZE 512M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
2.改变缺省临时表空间为刚刚创建的新临时表空间temp1
alter database default temporary tablespace temp1;
3.删除原来临时表空间
drop tablespace temp including contents and datafiles;
4.重新创建临时表空间
create temporary tablespace TEMP TEMPFILE ‘/data/dbfile/temp_01.dbf’ SIZE 5G REUSE AUTOEXTEND ON NEXT 512M MAXSIZE 20G;
ALTER TABLESPACE TEMP ADD TEMPFILE ‘/data/dbfile/temp_02.dbf’ SIZE 5G REUSE AUTOEXTEND ON NEXT 512M MAXSIZE 30G;
5.重置缺省临时表空间为新建的temp表空间
alter database default temporary tablespace temp;
6.删除中转用临时表空间
drop tablespace temp1 including contents and datafiles;