In this post, you’ll learn more about the Oracle ErrorORA-02444: Cannot resolve referenced object in referential constraints with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-02444: Cannot resolve referenced object in referential constraints
Reason for the Error ORA-02444: Cannot resolve referenced object in referential constraints
attempted to define foreign key referencing an object which cannot be resolved to a base table reference
How to fix the Error ORA-02444: Cannot resolve referenced object in referential constraints ?
You can fix this error in Oracle by following the below steps
referential constraints can only be defined on objects which can be resolve to base table reference