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-31469: cannot enable Change Data Capture for change set string

1 Answers  


ORA-17503: ksfdopn:string Failed to open file string

1 Answers  


CLSS-02202: voting device access took an excessive amount of time. (string sec)

1 Answers  


ORA-01877: string is too long for internal buffer

1 Answers  


PCC-00101: Lower case 'e' in floating point number is not ANSI

1 Answers  






ORA-24053: PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative

1 Answers  


PLS-00601: partition extended object names may only be used with tables

1 Answers  


NNL-00217: Controller is sleeping for number seconds

1 Answers  


ORA-01679: database must be mounted EXCLUSIVE and not open to activate

1 Answers  


DRG-50948: ABOUT clause required in the absence of a text index

1 Answers  


ORA-02855: Number of requests is less than the number of slaves

1 Answers  


ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.

1 Answers  


Categories