Re: 'no row' deadlock - ORA-00060

Correct.

It doesn't even have to be a unique index. Any index starting with the FK columns
will do.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Nuno Souto wrote in message <3c063c7f.9915051_at_news>...


>Jonathan Lewis doodled thusly:

>

>>

>>a)    Is the table involved in a parent/child relation

>>        where there is no index on the child table

>>        representing a foreign key

>>

>

>

>Jonathan, just a quick check:

>

>If the FK is, say, a column called COL_FK.  And there is no index on

>that column alone.  But there is a unique index on (COL_FK,COL_SEQ).

>This would have the same effect in negating deadlocks as the FK index

>you mention above?

>

>TIA for any feedback.  This relates to work I'm currently doing and

>I'd appreciate the heads-up.

>