Re: Deadlock Question

wagen123_at_yahoo.com wrote:
> Hi,
>
> Quote fron Steve Adams website - "you need indexes on all the foreign
> key columns. Otherwise, you need table locks to be disabled on any
> table that is missing a foreign key index"

If I'm not mistaken this is no longer the case with 9i and later (the child table lock)

One always has to be careful with articles on Oracle as Oracle is always elvolving and what was true a year or three ago may not be the case anymore. Can get quite "interesting" at times..

--
Billy