Re: What does thir error mean ?

Atif Ahmad Khan wrote:
>
> Hi, we have Oracle Workgroup Server 7.3.2 running under Solaris X86 2.5.1
> It has been working fine for over a week and all of a sudden I am getting
> the following error when running an update statement :
>
> 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
>
> I am fairly new to Oracle and would appreciate any help that you can
> provide. Thanks.
>
> Atif Khan
> aak2_at_ra.msstate.edu

The following was extracted from "Instant Messages" http://www.revealnet.com

   Oracle Product Document Library (C) Oracle Corporation   Manual: ORACLE 7.2 SERVER CODES Reference: A19483-2

 ORA-01562 failed to extend rollback segment ID = num

  Cause: A failure occurred while trying to extend the

          rollback segment. The problem is usually lack of
          space in the database to extend the rollback
          segment. 

  Action: This is usually followed by another message
          stating the cause of the failure. Shut down and
          take appropriate action for the error that caused
          the failure. If no other messages follow this
          message, the cause is probably lack of space in
          the database.