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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-758478/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26870952/viewspace-758478/