ORA-02267: column type incompatible with referenced column type - Oracle Database 12c Error Messages

Channel:
India java frm
Subscribers:
5,740
Published on ● Video Link: https://www.youtube.com/watch?v=q7vYqJ7V0r8


Duration: 2:20
3 views
0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

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.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database



Other Videos By java frm


2023-03-15ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications - Oracle Database 12c Error Message
2023-03-15ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications - Oracle Database 12c Error Msg
2023-03-15ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE ... - Oracle Database 12c Error Messages
2023-03-15ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE ... - Oracle Database 12c Error Messages
2023-03-15ORA-02277: invalid sequence name - Oracle Database 12c Error Messages
2023-03-15ORA-02275: such a referential constraint already exists in the table - Oracle Database 12c Error Msg
2023-03-15ORA-02274: duplicate referential constraint specifications - Oracle Database 12c Error Messages
2023-03-14ORA-02273: this unique/primary key is referenced by some ... - Oracle Database 12c Error Message
2023-03-14ORA-02270: no matching unique or primary key for this column-list - Oracle Database 12c Error Msg
2023-03-14ORA-02269: key column cannot be of LONG datatype - Oracle Database 12c Error Messages
2023-03-14ORA-02267: column type incompatible with referenced column type - Oracle Database 12c Error Messages
2023-03-14ORA-02266: unique/primary keys in table referenced by enabled ... - Oracle Database 12c Error Msg
2023-03-14ORA-02264: name already used by an existing constraint - Oracle Database 12c Error Messages
2023-03-14ORA-02263: need to specify the datatype for this column - Oracle Database 12c Error Messages
2023-03-14ORA-02262: ORA-string occurs while type-checking column ... - Oracle Database 12c Error Messages
2023-03-14ORA-02261: such unique or primary key already exists in the table - Oracle Database 12c Error Msg
2023-03-14ORA-02260: table can have only one primary key - Oracle Database 12c Error Messages
2023-03-14ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications - Oracle Database 12c Error Messages
2023-03-14ORA-02258: duplicate or conflicting NULL and/or NOT NULL ... - Oracle Database 12c Error Messages
2023-03-14ORA-02257: maximum number of columns exceeded - Oracle Database 12c Error Messages
2023-03-14ORA-02256: number of referencing columns must match ... - Oracle Database 12c Error Messages


Tags:
ORA-02267: column type incompatible with referenced column type
how to fix ORA-02267
oracle database 12c error messages
oracle database 12c error codes
oracle error messages
oracle database messages
oracle exception messages
sql errors
oracle sql
oracle error codes
12c
oracle 12c
ora errors
ora messages
oracle dba
oracle database administration
oracle tutorial