Hello All,

There is a tablespace RBSTBLSPACE. The size of the tablespace is 100M. Autoextend is off.

I have associated 2 rollback segment with that. RB1 and RB2.
I also have set an Optimal value.

I have executed a long statement. Suppose that has been associated with RB1.

My query is,

1) if the statement occupies all the blocks till optimal size ... and the statement yet to complete , what will happen? RB1 rollback segment still grow untill the full tablespace size has been occupied?

2) If it grows and occupies the total tablespace size , but the statement yet to finish, then what will happen? Will the whole statement rollback or it will again start occuping the first block in the tablespace?

An early response will be very much appreciated.

Thanks and regards

Sumit