I get this error
ORA-01555: snapshot too old: rollback segment number 12 with name "RBS13" too small.
We have commit in the program for every 200 record.
What is the solution..?
Make your rollback segments bigger OR commit for every 100 or 50 records.
You can take care of OPTIMAL parameter for your RB segments if its not set. Check out the docs.
make commit less often
larger extent size
Also you can increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.
"Greatest Rewards come only with Greatest Commitments!"
Click Here to Expand Forum to Full Width