收缩临时表空间
SQL> conn /as sysdba
已连接。
SQL> col name for a44;
SQL> select file#,name,bytes/1024/1024 mb from v$tempfile;

     FILE# NAME                                                 MB
---------- -------------------------------------------- ----------
         1 E:\ORACLE\APP\ADMINISTRATOR\ORADATA\WNPSAIL\        297
           TEMP01.DBF

SQL> select * from dba_temp_free_space;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP 311427072 311427072 310378496

SQL> alter tablespace temp shrink space;

表空间已更改。

SQL> select file#,name,bytes/1024/1024 mb from v$tempfile;

     FILE# NAME                                                 MB
---------- -------------------------------------------- ----------
         1 E:\ORACLE\APP\ADMINISTRATOR\ORADATA\WNPSAIL\ 1.9921875
           TEMP01.DBF

ITPub博客

oracle之临时表空间的收缩

最新文章