Re: Index and foreign key

From: VC <>
Date: Sat, 20 Dec 2003 17:48:58 GMT
Message-ID: <eY%Eb.164024$_M.745838_at_attbi_s54>

Hello Nick,

"NicK" <> wrote in message news:bs0op0$
> 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

Original text of this message