Re: ORA-01562

Was there another error message ?

No space on drive ? maxing out ?

y"Christoph Kukulies" <kuku_at_accms33.physik.rwth-aachen.de> wrote in message news:aenjq4$ngq$1_at_nets3.rz.RWTH-Aachen.DE...
> During an update of a database which is being done by
> issueing a lot of SQL statements like drop table / create table
> followed by insert statements the ominuous ORA-01562 error occurs:
>
> ORA-01562 failed to extend rollback segment number xxx
>
> I tried to find something in the online documentation but I didn't
> find anything pointing me to an immediate cure of the problem.
>
> I read about shrinking (but not increasing) a rollback segment.
> Also about taking a rollback segment offline. I found
> an explanation of the error like this:
>
> ORA-01562 failed to extend rollback segment number string
>
> 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 maintenance. Use SELECT
> SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE SEGMENT_ID=string (where
string is the segment number from the message) to determine the rollback
> segment name. Then use the ALTER ROLLBACK SEGMENT OFFLINE command to
take the rollback segment offline.
>
>
>
> All this doesn't bring me any further. I need some help.
>
>
> --
> Chris Christoph P. U. Kukulies kukulies_at_rwth-aachen.de
Received on Tue Jun 18 2002 - 11:29:06 CDT