- Oracle-Developer.com -

Navigation: Home  | Discussion Forums (Get expert advice)  |  Scripts  |  About Us  | Links  | Job Openings  
ORA-01555 snapshot too old
Comment on this Topic


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

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

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


Comment on ORA-01555 snapshot too old

 

Owned and Operated by Varun Jain, Inc, an Oracle Consulting Firm

Copyright ©2007 Oracle-Developer.com