Home » SQL & PL/SQL » SQL & PL/SQL » ora 01013 error (oracle 9i)
ora 01013 error [message #279331] Wed, 07 November 2007 17:42 Go to next message
cgeek4u
Messages: 1
Registered: November 2007
Junior Member
I am getting a ORA 01013 : User requested cancel of current operation while executing UPDATE <tableX> .....

This error is coming in production to display a page which dos not require a UPDATE to <tableX>. When I see the DataBase trace on my local server I see only select * from <tableX> no UPDATEs at all.

I am not understanding why I am getting timeout for UPDATE query when I am doing SELECT query on tableX.

This error is consistent when I am clicking for the same JSP.

Regards,
Bhargavi.

Re: ora 01013 error [message #279332 is a reply to message #279331] Wed, 07 November 2007 17:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Most likely you are hitting a BUG (new or known).
The alert_SID.log file should contain a reference to the ORA-03113 failure along with the name of the trace file.
Use the contents of the trace file to research the specific failure on http://metalink.oracle.com
Re: ora 01013 error [message #279338 is a reply to message #279332] Wed, 07 November 2007 18:56 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Also watch for un-indexed foreign keys on child tables of any table you are updating/deleting.
Previous Topic: Posting XML through PL/SQL by UTL_HTTP
Next Topic: Index rebuild
Goto Forum:
  


Current Time: Mon Feb 10 11:58:39 CST 2025