To find out which records are causing this error do an
alter table enable constraint xxxxxxx exceptions into exceptions;
this exceptions table can be created by running utlexcpxxx
The exceptions table after this statement is run would have rowids of the
rows causing problem. Do a delete of those rows or do an update of the
foreign key to the value which has a primary key on parent.
This would help
Satya
Violin wrote in message <35c2b69e.24530201_at_172.16.7.252>...
>Hello,I have an urgent problem.PLEASE HELP ME!
>
>I have 2 tables:
>
>TABLE1 TABLE2
>--------------------------------------- ---------------------------
>accept_no char(8) ord_no char(8)
>accept_num char(3) ord_num char(3)
>ord_no char(8) ord_qty number(11,4)
>ord_num char(3) ord_date char(8)
>accept_mark char(1) ord_mark char(1)
>chk_qty number(11,4)
>
>
>The primary key of TABLE1 is : accept_no+accept_num
>The primary key of TABLE2 is :ord_no+ord_num
>
>And TABLE1 has a foreign key (ord_no,ord_num) reference
>TABLE2 (ord_no,ord_num)
>
>But when I alter table add the constraint,there is an error:
>ORA-02298:cannot enable-parent keys not found.
>Why??
>Please Help me,Thank you so............... much!!!
Received on Tue Aug 04 1998 - 14:00:33 CDT
