Oracle Error ORA-01555: snapshot too old: rollback segment number string with name “string” too small

Oracle Error Message

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

Reason for the Error

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

Solution

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