Re: Index and foreign key
From: VC <boston103_at_hotmail.com>
Date: Sat, 20 Dec 2003 17:48:58 GMT
Message-ID: <eY%Eb.164024$_M.745838_at_attbi_s54>
Date: Sat, 20 Dec 2003 17:48:58 GMT
Message-ID: <eY%Eb.164024$_M.745838_at_attbi_s54>
Hello Nick,
"NicK" <nospam_at_emirates.net.ae> wrote in message
news:bs0op0$hsh8_at_news-dxb.emirates.net.ae...
> Hey VC!
>
> If you check out the Oracle press materials on Oracle 9i, it explicitly
> states that dead-locks are checked for and prevented.
Well, Oracle misled you. I can post a sample scenario where Oracle 9i dead-locks during primary key updates with unindexed foreign keys (if you are interested).
VC Received on Sat Dec 20 2003 - 18:48:58 CET