I am getting ora-01555- snap shot tool old error for an update statement , pls find the below.
This is a very simple update statement, i couldnt get the logic of how this ora error firing for
a update statement. Anybody can shower some clue on how this could happen ?
The below is taken from alert log .
ORA-01555 caused by SQL statement below (Query Duration=1576 sec, SCN: 0x09a2.5dda3165):
Fri Sep 16 16:33:40 2011
UPDATE SSPT_NETWORK_DETAILS SET INCLUDE_OFFERS = 'Yes' WHERE SESS_ID = SESS_ID