Oracle Error Message
ORA-02444: Cannot resolve referenced object in referential constraints
Reason for the Error
attempted to define foreign key referencing an object which cannot be resolved to a base table reference
Solution
referential constraints can only be defined on objects which can be resolve to base table reference