I have asked this before, and the only answer I get from Oracle is thats the way it works. I believe it is a bug, but Oracle says its a feature...

-----Original Message-----
From: kazi
[mailto:oracledba-ezmlmshield-x43876114.[Email address protected]
Sent: Thursday, March 31, 2005 06:10
To: LazyDBA Discussion
Subject: Re: UnIndexed FKs


In case of Un-indexed foriegn keys an delete from master table,
whole related table is locked. Why? I also want to nknow.

KAzi

fahd-m wrote:

>Hi,
> Why Un-indexed foriegn keys lead to deadlocks?
>
>Thanks,
>Fahd
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page