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

Error Type: ORA

• Additional information for ORA-02270: no matching unique or primary key for this column-list02270
Discussions and solutions for Oracle Database Error ORA-02270: no matching unique or primary key for this column-list Developer anwers for Oracle Database Error ORA-02270: no matching unique or primary key for this column-list FAQs for ORA-02270: no matching unique or primary key for this column-list search others tips for ORA-02270: no matching unique or primary key for this column-list