Gopinath

• Aug 17th, 2006

 

I think its snapshot too old error.

saradba

 Profile 

• Aug 19th, 2006

 

yes,  its snapshot too old error.

so, u increase the rbs siize.

paparao

• Oct 23rd, 2006

 

This shanshot too old. -> problem occurs generally in 9i only.  Whether in 10g, at the time of tablespace creation, retuntion guarentee is applied it automatically we can supress( by default in oracle 10g retuntion gurantee is flase -- be careful).

This problem generally occur in the followin situation.

for eg. One user continuously updating on one table, where as the another user trying to retrieve conituously on that same table, with in the time of retention guarentee period.

senthilora

 Profile Answers by senthilora 

• Sep 24th, 2007

 

ORA-1555 error can occur in Oracle 10g also even with UNDO RETENTION GUARANTEE enabled.
 
ORA-1555 happens, when Oracle server process could not find the block-image in UNDO tablespace for the read-consistency.

Usually this happens when there is not enough space in UNDO TABLESPACE (in10g UNDO RETENTION GUARANTEE has been enabled with small period of time).