ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued...

From: Zareh Dergevorkian <zareh_at_earthlink.net>
Date: 1996/03/22
Message-ID: <31527228.78BD_at_earthlink.net>#1/1

When issueing an UPDATE or DELETE SQL statement to an Oracle WGS2000 NT server, I get the error message ORA-01562: ...failed to extend rollback segment..

I have allocated upto 200MB of rollback against a 250MB user_data name space...

the statements that generate the error are obviousely updating/deleting more than what can be held in the RB segment... but what I'm wondering is why when the RB seg is almost as large as the entire database itself, and the statements only affect roughly 50+K recs (out of 1.5M+ recs), do I get an error failed to extend rb seg... ??????

please HELP !!!

zdg~~~~~ Received on Fri Mar 22 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Craig: "Re: Boilerplate text disappears etc. (Forms 4.5 / Solaris 2.4)"
Previous message: Jim Smith: "Re: Split c.d.o - Straw poll results"
Next in thread: Timo Haatainen: "Re: ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued..."
Reply: Thomas J Kyte: "Re: ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued..."
Reply: Timo Haatainen: "Re: ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued..."
Maybe reply: Brian M. Biggs: "Re: ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message