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-24345: A Truncation or null fetch error occurred

1 Answers  


EXP-00015: error on row number of table string, column string, datatype number

1 Answers  


PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function

1 Answers  


ORA-06321: IPA: Cannot reach the remote side

1 Answers  


QSM-01127: query rewritten with multiple MVs

1 Answers  






ORA-14157: invalid subpartition name

1 Answers  


RMAN-10018: error cleaning up channel context

1 Answers  


LFI-00119: Unable to Abort an Unprotected file.

1 Answers  


ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL

1 Answers  


ORA-27214: skgfrsfe: file search failed

1 Answers  


ORA-27303: additional information: string

1 Answers  


ORA-31035: Could not bind locked resource to path string/string

1 Answers  


Categories