Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SOS:ora-02298:parent keys not found

SOS:ora-02298:parent keys not found

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Sat, 01 Aug 1998 07:07:22 GMT
Message-ID: <35c2b69e.24530201@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 Sat Aug 01 1998 - 02:07:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US