When Ever This Error occurs "ORA - 1555" Error or "Snapshot to old Error" , Due to Less Undo Tablespace or Undo Retention
Why It will occur or which Situation :
When user try to Fetch some data from a table at the same time another user update the data in the same row,the select user or select query will get the old image in undo tablespace and new image is not written in data block and a situation where old images are expire the select user will receive ORA - 1555 Error.
We can have any Number of undo and temp tablespace but default is only one.
Note :
if above error will raise we should wait for the undo retention time mostly.
Why It will occur or which Situation :
When user try to Fetch some data from a table at the same time another user update the data in the same row,the select user or select query will get the old image in undo tablespace and new image is not written in data block and a situation where old images are expire the select user will receive ORA - 1555 Error.
We can have any Number of undo and temp tablespace but default is only one.
Note :
if above error will raise we should wait for the undo retention time mostly.
No comments:
Post a Comment