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: 25571
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: privileges......
Next Topic: check if oracle key word is used in a column (merged)
Goto Forum:
  


Current Time: Sat Aug 19 11:58:11 CDT 2017

Total time taken to generate the page: 0.01926 seconds