Referential Integrity and deadlock on delete
From: Ralph Byrd <6648470_at_LMSC5.IS.LMSC.LOCKHEED.COM>
Date: Fri, 6 May 1994 20:16:21 GMT
Message-ID: <16FAEBAB9S86.6648470_at_LMSC5.IS.LMSC.LOCKHEED.COM>
Date: Fri, 6 May 1994 20:16:21 GMT
Message-ID: <16FAEBAB9S86.6648470_at_LMSC5.IS.LMSC.LOCKHEED.COM>
I am encountering a deadlock where two process are deleteing rows from the top table in a referential structure. Oracle 7.0.12, Sun OS 4.1
The tables are lower in the structure (1 master, many detail tables). The deletes >> appear << to process the detail tables in different order. This seems inherently poor design, and I can't believe it is done this way
Can anyone confirm that this is not the case?
ALSO - any help on reading the .trc file from this deadlock? Thanks for your help.
Ralph Byrd
RBYRD_at_lmsc.lockheed.com
Received on Fri May 06 1994 - 22:16:21 CEST