SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while enabling forien key constraint

599269Nov 6 2007 — edited Nov 6 2007

HI forum,

I am facing a problem while enabling constraint..pls see the statement below.

SQL> alter table EVENT enable validate constraint EVENT_4FK;
alter table EVENT enable validate constraint EVENT_4FK
*
ERROR at line 1:
ORA-02298: cannot validate (APPO.EVENT_4FK) - parent keys not
found
EVENT_4FK FK is refering another table and that primary key is existing and it is in enabled ...

Pls help me to solve this issue..

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2007

Added on Nov 6 2007

4 comments

291 views