hi i am getting this error while i am trying to insert records in to Oracle Enterprise usinfg auto generated insert then update.
Unable to use a record for update due to ORA-00060: deadlock detected while waiting for resource
ORA-00060 Deadlock
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm pretty sure that what was meant there was to remove the Oracle stage.
Think about possible causes of deadlock. Might the same key be arriving from more than one partition? Are you trying to insert into the same table as one from which you are selecting?
Think about possible causes of deadlock. Might the same key be arriving from more than one partition? Are you trying to insert into the same table as one from which you are selecting?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom