Oracle DBA, How To, Error, Cause and Action

ORA-02256: number of referencing columns must match referenced columns

ORA-02256: number of referencing columns must match referenced columns




Cause: The number of columns in the foreign-key referencing list is not equal to the number of columns in the referenced list.




Action: Make sure that the referencing columns match the referenced columns.