[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ORA-01555 - For update Statement

Posted on 2011-09-22
4
Medium Priority
?
539 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:manzoor_dba
  • 2
4 Comments
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 36579306
- 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

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

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 36579400
UPDATE SSPT_NETWORK_DETAILS SET INCLUDE_OFFERS = 'Yes' WHERE SESS_ID = SESS_ID

I must presume that this is in the context of a stored proc.
I then must presume that the stored proc has a parameter, names SESS_ID, having hence the same name as the table's column name
if those 2 presumptions are correct, simply change the procedure's parameter name, for example to p_SESS_ID, and the sql to:

UPDATE SSPT_NETWORK_DETAILS SET INCLUDE_OFFERS = 'Yes' WHERE SESS_ID = p_SESS_ID

and your problem should be gone.
0
 
LVL 5

Author Comment

by:manzoor_dba
ID: 36579412
Hi Angelll,

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

Author Closing Comment

by:manzoor_dba
ID: 36585929
Thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question