TEMP表空間報ORA-1652的處理

一個庫收到這個報錯，檢查檔案系統100%了，清除後仍然報這個錯，原來在檔案系統滿後oracle把臨時表空間檔案offline，以下是處理日誌：

ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Fri Apr 12 16:01:21 2013
alter database tempfile '/opt/oracle/oradata/oracle/temp01.dbf' online
Fri Apr 12 16:01:21 2013
Completed: alter database tempfile '/opt/oracle/oradata/oracl
Fri Apr 12 16:06:32 2013
Thread 1 advanced to log sequence 13096
  Current log# 3 seq# 13096 mem# 0: /opt/oracle/oradata/oracle/redo03.log
Fri Apr 12 16:06:46 2013