Re: Rollback

From: Robert Chin <robert_chin_2000_at_hotmail.com>
Date: Fri, 07 Dec 2001 04:54:13 GMT
Message-ID: <VXXP7.15901$MX1.4916788@news02.optonline.net>

> If I don't commit and reach the max extents for the segment will I
> get an error message

Yup, mate, each transaction is assigned *one* rbs (guys, correct me if I'm wrong on this)

you'd blow your rbs, and you'd get these nasty bitchings from Oracle: ORA-01562: failed to extend rollback segment number xblahx ORA-01628: max # extents reached

And at this point you're screwed because all your transactions are rollbacked and gone.

--
Robert Chin

<peter.mckenzie_at_health.wa.gov.au>


> If I start updating data within an sql session I am allocated a rollback

> segment.  If I don't commit and reach the max extents for the segment will

I


> get an error message or will I then be given access to another rollback

> segment?

>

> How does Oracle decide which rollback segment to assign ?

>

> Thanks

>

>

>

>  -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the

eb  -----


>   http://newsone.net/ -- Free reading and anonymous posting to 60,000+

groups


>    NewsOne.Net prohibits users from posting spam.  If this or other posts

> made through NewsOne.Net violate posting guidelines, email

abuse_at_newsone.net

Received on Thu Dec 06 2001 - 22:54:13 CST