这个也可以 缩小
SQL> select * from dba_temp_files;
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- -----------
E:\ORADATA\ORAWIN\TEMP01.DBF 1 TEMP 2483447398 3031552 AVAILABLE 1 YES 3435972198 4194302 80 2483342540 3031424
SQL> alter database tempfile 'E:\ORADATA\ORAWIN\TEMP01.DBF' resize 200m;
Database altered
SQL> select * from dba_temp_files;
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- -----------
E:\ORADATA\ORAWIN\TEMP01.DBF 1 TEMP 209715200 25600 AVAILABLE 1 YES 3435972198 4194302 80 208666624 25472
SQL>
SQL>
SQL> alter database tempfile 'E:\ORADATA\ORAWIN\TEMP01.DBF' resize 150m;
Database altered
可能会报错,因为可能使用的空间大于你要RESIZE的空间