Re: Rollback

From: Sylvain Leclerc <sleclerc_at_magrit.com>
Date: 7 Dec 2001 13:34:00 -0800
Message-ID: <12c52f7c.0112071334.72ec8079@posting.google.com>

Rollbacks cycle within themselves if possible. A transaction cannot span across several roolbacks, so yes you'll get an error.

You get the next available one. If you want (or need) to choose, you must issue a "set transaction use rollback segment <segment_name>;" at the beginning of your transaction.

peter.mckenzie_at_health.wa.gov.au wrote in message news:<9upcq6$u78$1_at_news.netmar.com>...
> 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 Web -----
> 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 Fri Dec 07 2001 - 15:34:00 CST