Re: Is a tablespace does not have an rollback segment associated with it, what will happen

Tablespaces don't have rollback segments associated with them. There must be a pool of on-line rollback segments available to all Users of the database. When they begin a transaction, Oracle determines which of the available segments is least active, and places their transaction in that segment.

For that purpose, it is irrelevant which tablespace is being affected by that transaction (particularly since complex transactions might be affecting multiple segments simultaneously, all housed in separate tablespaces -eg, table data and index entries).

Provided at least one non-system rollback segment is available and online, then the strict answer to your question is 'nothing will happen'. If you do not have any non-system rollback segments available (ie, you only have the one called SYSTEM which is created when you create a database, and cannot be taken offline), then you will get the error message "cannot use system rollback segment for transactions in non-system tablespace" (or words to that effect). The cure is to have a non-system rollback segment online.

Regards
HJR "Tim Lee" <timothy.yw.lee_at_philips.com> wrote in message news:9877ga$fvr105_at_imsp212.netvigator.com...
> Dear All:
>
>
> Could someone pls. tell me:
> If a tablespace does not have an rollback segment associated with it, what
> will happen?
>
>
> Thanks!
>
>
Received on Thu Mar 08 2001 - 00:23:38 CST