ROLLBACK SEGMENT ERROR ORA-01555:

Hi ,

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..?

SK Das

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

higher minextents

larger extent size

Also you can increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.
Sandy