ORA 2270 - cheeyoung/sqlplus-public GitHub Wiki

74 ORA-02100 to ORA-04099

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