ORA-00060: deadlock detected while waiting for resourc

pillip · Post by **pillip** » Tue Jan 26, 2010 2:51 pm

Hi,

I am getting the following error when data is getting upserted into the table in the oracle stage.

Kindly let me know what could be the issue.

I have checked that there are no locks on the table. Seems that there are table level locks on the table.

Thanks,
Prasanna

chulett · Post by **chulett** » Tue Jan 26, 2010 4:15 pm

A quick google for that Oracle error will let you know what the issue is as it is well documented out there. Simplest solution would be to run the job on one node only.

abhijain · Post by **abhijain** » Fri Jan 29, 2010 5:48 am

It is purely an oracle error not a datastage problem. Hope this link-TechOnthenet helps you to look into this.

chulett · Post by **chulett** » Fri Jan 29, 2010 8:19 am

It is an Oracle error that could very well be caused by DataStage, hence the node question.