Oracle重新创建临时表空间

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;