ORA-02270: no matching unique or primary key for this column-list - Oracle Database 12c Error Msg

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


Duration: 1:36
4 views
0

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

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.

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



Other Videos By java frm


2023-03-15ORA-02283: cannot alter starting sequence number - Oracle Database 12c Error Messages
2023-03-15ORA-02282: duplicate or conflicting ORDER/NOORDER specifications - Oracle Database 12c Error Message
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


Tags:
ORA-02270: no matching unique or primary key for this column-list
how to fix ORA-02270
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