ORA-02270: no matching unique or primary key for this column-list - Oracle Database 12c Error Msg

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-02270: no matching unique or primary key for this column-list.
Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement gives a
column-list for which there is no matching unique or primary key constraint in the
referenced table.
Action: Find the correct column names using the ALL_CONS_COLUMNS catalog view.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database