Thx so far, was: How do I use a certain rollback segment?

Hi Vladimir,Sybrand, Mark and all the others who might read this thread.

First I wish to thank you for your guidance. I'm aware of the fact that setting the rollback segment has to be the first statement in the transaction. I even tried to set the rollback segment outside of the procedure (in sql*plus) but the result was (according to my dba) the same.

But now (without changing anything), some hours later, everything works fine. So I doubt if my dba wore his glasses in the morning ;-).

Please give another glimpse of paradise by providing me with the solution how to detect the used rollback segment (built-in package / system view).

Thanks again to everyone,
Guido Received on Tue Apr 23 2002 - 09:11:17 CDT