Oracle Deadlock

[Aravind]

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

[ketfos]

Hi,
You already ahve the answer to the problem.
How are having the same link table for reading and simultaneous updates?


Ketfos

[Aravind]

Hi,
You already ahve the answer to the problem.
How are having the same link table for reading and simultaneous updates?


Ketfos

But evenif I do that the record will first do a lookup and then go for the insert/update right. Am I missing out something..

[Aravind]

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