While inserting; deadlock is happening

[yousuff1710]

Hi All,

In one of my job, I am inserting 44000 records into a table using Oracle Enterprise stage.
The opions used: User defined update & insert; Insert then Update; Also using same insert query as in INSERT INTO also in Update query i.e INSERT INTO in both Insert & Update SQL.
After the first job run, it was succesfull.
But if I run for 2nd time after deleting the records in the target table; the job is aborting in the middle giving following error:
ORC_D_DMA_FSPG_PIANI_GEST,1: Array execute failed for insert:
insert is: INSERT INTO TES1_U_NSC_IGPB_DMA_G1_ESE.D_DMA_FSPG_PIANI_GEST (DATA_FSPG_DATA_OSS, FK_FSPG_DPGC_ID, FK_FSPG_DESF_ID, FK_FSPG_DCAM_ID................
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource

Soln: For the next run, in the enterprise stage, I deleted the query, again reentered. Then the job run successfully.
This is happening like this for subsequent runs.

I just want to know what the exact reason for this deadlocks.

Thanks in advance
Yusuf.

[miwinter]

Contention with another process running against that table or associated DB objects?

[mikegohl]

Could be contention in you own process. Tell us a little about the design.