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
>
You will get error because one transaction can use only one rollback segment.
HTH,
Tho Nguyen
Received on Fri Dec 07 2001 - 04:34:38 CST
