Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SOS:ora-02298:parent keys not found
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 Sat Aug 01 1998 - 02:07:22 CDT