Database Error Messages

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