DSXchange

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.

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

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