Oracle DB Error ORA-02270 no matching unique or primary key for this column-list

The following is the cause of this error:

An attempt was made to reference a unique or primary key in a table with a CREATE or ALTER TABLE statement when no such key exists in the referenced table.

Action you can take to resolve this issue: Add the unique or primary key to the table or find the correct names of the columns with the primary or unique key, and try again.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related