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!

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

Original text of this message