Re: What does thir error mean ?
From: Lun Wing San (Oracle) <"Lun>
Date: 1996/11/16
Message-ID: <328EB54A.23B8_at_qrcsun.qrc.org>#1/1
Date: 1996/11/16
Message-ID: <328EB54A.23B8_at_qrcsun.qrc.org>#1/1
Atif Ahmad Khan wrote:
> update test_table
> *
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 4
> ORA-01650: unable to extend rollback segment R03 by 64 in tablespace RBS
Your rollback segment is run out of space during the transaction. The undo information cannot write to rollback segment. You can avoid this problem by increasing the size of the rollback segment by using ALTER ROLLBACK SEGMENT ... (Please refer to the SQL Reference Manual for detail).
--- Name : Lun Wing San Title : Oracle Application Developer of Hong Kong Productivity Council Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841Received on Sat Nov 16 1996 - 00:00:00 CET