SOS:ora-02298:parent keys not found
From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Sat, 01 Aug 1998 07:49:57 GMT
Message-ID: <35c2c8a3.29143882_at_172.16.7.252>
[Quoted] [Quoted] Hello,I have an urgent problem.PLEASE HELP ME!
Date: Sat, 01 Aug 1998 07:49:57 GMT
Message-ID: <35c2c8a3.29143882_at_172.16.7.252>
[Quoted] [Quoted] 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!!!
Please Cc to : violin.hsiao_at_mail.pouchen.com.tw
Received on Sat Aug 01 1998 - 09:49:57 CEST