Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01555 – snapshot too old: rollback segment number string with name “string” too small

Oracle Database Error Code ORA-1555 Description :

snapshot too old: rollback segment number string with name “string” too small

Error Cause:

rollback records needed by a reader for consistent read are overwritten by other writers

How to Solve :

If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments