amankhan
asked on
Regarding SET TRANSACTION USE ROLLBACK SEGMENT rbsbig;
Hi,
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.
Help Appreciated.
Thanks
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.
Help Appreciated.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Computer101
EE Admin