DSXchange

Hi,

I have 9 million records in my source table. When i tried to load all the records then i got the following error:
Array execute failed for insert:
qlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource

When i filter for 50 records in the source then the job runs successfully.

I have given the insert mode as UPSERT. In that update is a dummy query (Where 1=2)

Your help is highly appreciated.

Thanks in advance.

Is there are any bitmap indexes enabled on that table.If you haveany bitpam indexes please make unusable before loading.

Same table as source?

Thanks for your replies.

Target table is different from source table. No index on target table.

But one stored procedure (which will refer the target stage) is used before the target stage

try to use sequential mode when insert.

Yes. I have tried it. But still getting the same deadlock error

- Have you tried using the Load option instead of insert?
- Have you changed the upsert time for commit / rows for commit environment variables?

Gaby