-
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
-
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,