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>


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

Original text of this message