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