Problem:
There is a procedure to insert records in few tables and to update in few
tables , after processing X records or so , it is failing with the below error,
ORA-01555: snapshot too old: rollback segment number 3 with name "RBS2" too small .
Solution:
You can try this solution:
Loop
Process data;
Perform update/delete on table a.
Increase record-counter
If counter > n
Then
commit;
Reset ounter;
End if
End loop;
Process data;
Perform update/delete on table a.
Increase record-counter
If counter > n
Then
commit;
Reset ounter;
End if
End loop;
or reset the parameter 'undo_retention' value > 36000 .
