Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NNO-00059: cannot construct topology checkpoint file name

1 Answers  


ORA-01526: error in opening file 'string'

1 Answers  


RMAN-08524: input controlfilecopy name=string

1 Answers  


ORA-16557: The database is already in use.

1 Answers  


ORA-24365: error in character conversion

1 Answers  






ORA-22981: must specify a table/view having system generated OID

1 Answers  


LSX-00174: "~S" is not a valid derivation of "~S"

1 Answers  


ORA-40253: no target counter examples were found

1 Answers  


ORA-19676: one or more files failed during proxy backup or restore

1 Answers  


ORA-24334: no descriptor for this position

2 Answers  


TNS-12209: TNS:encountered uninitialized global

1 Answers  


PCC-02317: illegal cast type expression

1 Answers  






Categories