DSXchange

Hi,

i am Using doing lookup and loading the data into Target.Target table contain Unique Key constrants,so i used remove Duplicate for that feild but it still showing the Error:ORA-00060: deadlock detected while waiting for resource.
Please tell what are the reasion for this error.

Regards,
Sandeep

Have you talked to your DBA? Have you Googled for that error?

http://www.orafaq.com/faq/what_is_a_dea ... ock_errors

Check The Target has Any Lock.If it so, Remove the locks and run the job.

You don't fix deadlocks. You prevent them.

I've seen situations where a deadlock occurs when there are multiple rows incoming with the same keys. If ORACLE stage isn't partitioned by the key, then it's possible for an upsert operation to occur on the same record in two different partitions (nodes) and thus using 2 different oracle connections. This contention can cause a deadlock as well.