Regarding SET TRANSACTION USE ROLLBACK SEGMENT rbsbig;
Posted on 2007-10-17
I am using this in my pl/sql code. The following line:
SET TRANSACTION USE ROLLBACK SEGMENT rbsbig;
After this line, I am updating a table and then commiting it.
When i run this package, its throwing this message:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode 2
What exactly this 'TRANSACTION USE ROLLBACK SEGMENT ' does. Also, what that error message is.
Can anybody explain with an example and how to get rid of this error if possible.