Hi,
Another issue.
Job design is as follows
HashFile --> Transformer --- > INSERT/UPDATE TO TABLE
|
|
Lookup Table
Lookup table is the same table that i am inserting and updating to..
Will this work ... In the log i can see oracle deadlock messages
can it be due to simulatneous read/write by this job
Thanks in advance
Oracle Deadlock
Moderators: chulett, rschirm, roy
Re: Oracle Deadlock
I thought of two ways
(*) Having the update records to be in a sequential file and then do the update operation afterwards
(*) cHAGNE THE ARRAY SIZE AND THE ROW TRANSACTION TO 1 IN THE ORACLE STAGE.
Will this solve the probelm.
Thanks in advance
(*) Having the update records to be in a sequential file and then do the update operation afterwards
(*) cHAGNE THE ARRAY SIZE AND THE ROW TRANSACTION TO 1 IN THE ORACLE STAGE.
Will this solve the probelm.
Thanks in advance