Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-02267

column type incompatible with referenced column type

Cause

The data type or collation of the referencing column was incompatible with the data type or collation of the referenced column.


Action

Select a compatible data type for the referencing column. Also, the collation of a character column in a foreign key must match the collation of the corresponding column in the primary key.