C:\>oerr ora 01562
0156201562, 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.
回滚段没有必要那么大吧?use rolllback segments了吗? 应该还有其他的错误信息吧?
Check your transaction firstly, then check the Rollback Segment usage by V$ROLLSTAT, V$TRANSACTION, V$SESSION:
SELECTU.NAME, T.ADDR, T.USED_UBLK FROM V$ROLLNAME U, V$TRANSACTIONT WHERE U.USN=T.XIDUSN