Oracle DBA, How To, Error, Cause and Action

ORA-02428: could not add foreign key reference

ORA-02428: could not add foreign key reference




Cause: could not add a foreign key reference because of error in declaration. Either referenced table does not exist or table does not have an unique key.




Action: make sure referenced table exists and/or has unique key