If you make it offline once you are finished ONLY, other transactions will share the large rollback segment. If you don't want to share it take it OFFLINE as soon as you assign the transaction to the segment. As I said, NO other transactions will be able to access it whilst the rollback's segment is in OFFLINE-PENDING state.

And remember, an explicit commit will end the current transactions assignement to the SET TRASACTION TO ROLLBACK SEGMENT.

*Oh, my 500th post, well, time to take a tiny bow. Slow and steady they say.*

Cheers

[Edited by grjohnson on 04-14-2002 at 07:27 PM]