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


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)27885841
Received on Sat Nov 16 1996 - 00:00:00 CET

Original text of this message