ORA-02298: cannot validate (USER.FK) - parent keys not found
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-02298: cannot validate (USER.FK) - parent keys not found

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    ORA-02298: cannot validate (user.fk) - parent key not found

    I'm trying to enable foreign keys but getting this error message. this is command that I used:

    alter table enable validate constraint ;

    if I used enable novalidate constrains, I can enable foreign keys.

    My question is is there a way to validate constraint that's been enabled?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Cause: An ALTER TABLE ENABLE CONSTRAINT command failed because
    the table has orphaned child records.
    Action: Make sure that the table has no orphaned child records before issuing
    an ALTER TABLE ENABLE CONSTRAINT command. For more information
    about ALTER TABLE and ENABLE CONSTRAINT,
    "Greatest Rewards come only with Greatest Commitments!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width