Oracle临时表空间重建(三)

没有发现offline 的文件，果断重建临时表空间.业务需要，时间比较紧

SQL> create temporary tablespace temp2 TEMPFILE '/oradata/test02/test02/temp02.dbf'
2 SIZE 512M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;

Tablespace created.

改defualt temp tablespace

SQL> alter database default temporary tablespace temp2;

Database altered.

删除老的temp 表空间
SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.

正常

----The end ------