Re: Rollback

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 7 Dec 2001 02:07:11 -0800
Message-ID: <a20d28ee.0112070207.732f4cb7@posting.google.com>

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

No version again. Sigh!
In Oracle 8i and before you will get an error message and your transaction will rollback automatically to the last statement, unless you trap the error and rollback explicitly. The rollback segments are assigned in a more or less round-robin fashion.
A little reading of the Oracle Concepts manual on rollback is not going to harm you.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Dec 07 2001 - 04:07:11 CST