Re: SOS:ora-02298:parent keys not found

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Sat, 1 Aug 1998 12:57:32 +0200
Message-ID: <6purha$87q$1@news.worldonline.nl>

Hello Violin,

You have some records in the child table which have a key which does not exist in the Parent table.
Either fix this problem, or (faster, supposing you have only test-data in the tables)
delete all records and you can enable the constraint.

Good luck, Roelof

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

Violin heeft geschreven in bericht <35c2b69e.24530201_at_172.16.7.252>...
>Hello,I have an urgent problem.PLEASE HELP ME!
>
>I have 2 tables:
>
>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 - 05:57:32 CDT