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



ORA-01555: snapshot too old: rollback segment number string with name "string" too small..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32809: foreign queue string is already registered

1 Answers  


PCC-02352: out of bounds bind position from PL/SQL

1 Answers  


PCB-00322: EXEC SQL LOB statements an Oracle extension

1 Answers  


ORA-24337: statement handle not prepared

2 Answers  


NID-00334: The following datafiles are not checkpointed to string:

1 Answers  






ORA-16806: Supplemental logging is not turned on.

1 Answers  


ORA-01876: year must be at least -4713

1 Answers  


NNL-00288: No cache flush currently scheduled

1 Answers  


ORA-22804: remote operations not permitted on object tables or user-defined type columns

1 Answers  


ORA-30337: multiple JOIN KEY clauses specified for the same parent level

1 Answers  


ORA-29906: indextype string.string does not exist

1 Answers  


ORA-16002: database already open for read-write access by another instance

1 Answers  


Categories