标题: 一个错误failed to extend rollback怎么处理啊？ [打印本页] 作者: ilovetc 时间: 2006-06-28 18:33 标题: 一个错误failed to extend rollback怎么处理啊？ 我使用的一个软件，日志报错如下：
FXZ[ORACLE]:ORA-01562:failed to extend rollback segment number 3
ORA-01628:max # extends(121) reached for rollback segment R02
请问：我是一个新手，只知道看看日志，怎么处理不清楚。楼主和大虾尽量详细点，
万分感谢！！再拜◎作者: macrodba 时间: 2006-06-29 14:12
01562, 00000, "failed to extend rollback segment number %s"
// *Cause: Failure occurred when trying to extend rollback segment
// *Action: This is normally followed by another error message that caused
// the failure. You may take the rollback segment offline to perform
// maintainence. Use the alter rollback segment offline command
// to take the rollback segment offline.作者: macrodba 时间: 2006-06-29 14:13
01628, 00000, "max # extents (%s) reached for rollback segment %s"
// *Cause: An attempt was made to extend a rollback segment that was
// already at the MAXEXTENTS value.
// *Action: If the value of the MAXEXTENTS storage parameter is less than
// the maximum allowed by the system, raise this value.作者: Jackson_cu 时间: 2006-06-30 10:40
提示: 作者被禁止或删除 内容自动屏蔽