Oracle DBA, How To, Error, Cause and Action

ORA-02444: Cannot resolve referenced object in referential constraints

ORA-02444: Cannot resolve referenced object in referential constraints




Cause: attempted to define foreign key referencing an object which cannot be resolved to a base table reference




Action: referential constraints can only be defined on objects which can be resolve to base table reference