Re: SOS:ora-02298:parent keys not found
Date: Mon, 03 Aug 1998 13:54:37 GMT
Message-ID: <6q4fet$1e$1_at_nnrp1.dejanews.com>
You need to read the docs on primary key and foreign keys, how they relate and how you can use the exceptions table to find out which children dont have parents and decide what to do from there. It is explained rather well in the oracle docs.
In article <35c2c8a3.29143882_at_172.16.7.252>,
violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> 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
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 03 1998 - 15:54:37 CEST