How to fix the Oracle error ORA-02270: no matching unique or primary key for this column-list?

In this post, you’ll learn more about the Oracle ErrorORA-02270: no matching unique or primary key for this column-list with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-02270: no matching unique or primary key for this column-list

Reason for the Error ORA-02270: no matching unique or primary key for this column-list

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.

How to fix the Error ORA-02270: no matching unique or primary key for this column-list ?

You can fix this error in Oracle by following the below steps

Find the correct column names using the ALL_CONS_COLUMNS catalog view