>>
>>Do you have un-indexed foreign key columns pointing to this PK ?
>>
>
>
> ncaa_bracket_at_NCAA> select constraint_name, constraint_type, table_name
> from user_constraints where r_constraint_name='DIV_PK';
>
> no rows selected
>
> no other user references it either.
>
> btw, pk exists
> ncaa_bracket_at_NCAA> select constraint_name, constraint_type, table_name
> from user_constraints where table_name='DIV';
>
> CONSTRAINT_NAME C TABLE_NAME
> ------------------------------ - ------------------------------
> DIV_PK P DIV
>
> And I think that's only needed when updating PK.
> .......
> We run Oracle 9.2.0.6 on RH4 AMD
> remove NSPAM to email
Any triggers on the table that do stuff on update ?
Received on Wed Mar 15 2006 - 14:19:28 CST
