Rollback

From: <peter.mckenzie_at_health.wa.gov.au>
Date: 7 Dec 2001 03:24:54 GMT
Message-ID: <9upcq6$u78$1@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 Thu Dec 06 2001 - 21:24:54 CST