回收临时表空间

 

回收临时表空间

SQL>alter database tempfile 'e:\oracle\oradata\ora8\temp01.dbf' drop ;
Database altered.
SQL>alter tablespace temp add tempfile
2'e:\oracle\oradata\ora8\temp01.dbf'
3 size 2048M reuse autoextend on next 100M;
Tablespace altered.
SQL> select d.file_name, d.file_id, d.tablespace_name, d.bytes from dba_temp_files d;

FILE_NAME FILE_ID TABLESPACE_NAME BYTES
------------------------------------ ---------- --------------- ----------
e:\ORACLE\ORADATA\YNRMDB\TEMP01.DBF 1 TEMP 2147483648