<div>
- there is a long explanation on this on 'Ask Tom'. see if the article could assist you to find the cause:<br />
<a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:4458737588211888::::P11_QUESTION_ID:275215756923" rel="ugc nofollow">http://asktom.oracle.com/pls/asktom/f?p=100:11:4458737588211888::::P11_QUESTION_ID:275215756923</a><br />
<br />
- looking at your update statement, would it the same as:<br />
UPDATE SSPT_NETWORK_DETAILS SET INCLUDE_OFFERS = 'Yes'
</div>


- there is a long explanation on this on 'Ask Tom'. see if the article could assist you to find the cause:
http://asktom.oracle.com/pls/asktom/f?p=100:11:4458737588211888::::P11_QUESTION_ID:275215756923 [http://asktom.oracle.com/pls/asktom/f?p=100:11:4458737588211888::::P11_QUESTION_ID:275215756923]

- looking at your update statement, would it the same as:
UPDATE SSPT_NETWORK_DETAILS SET INCLUDE_OFFERS = 'Yes'

<div>
Hi Angelll,<br />
<br />
Thanks for pointing me that.. will inform the developement guys and get back.. 
</div>


Hi Angelll,

Thanks for pointing me that.. will inform the developement guys and get back..

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

</div>
</div>


Hi All,

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


ORA-01555 - For update Statement

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.