Skip to Main Content

Oracle Database Discussions

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!

ORA-02298 Cannot validate - parent keys not found

bobhJun 8 2004 — edited Jun 9 2004
When trying to create a Foreign key (ou_fk) on table [FACT], referencing table [OU] which has a primary key (ou_pk), I get the error "ORA_02298: Cannot validate (SCHEMA.OU_FK) - parent keys not found". Both tables have a related column that the keys reference. Same result with trying to create other foreign keys on [FACT]to different tables. What is wrong here?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2004
Added on Jun 8 2004
7 comments
6,862 views