ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE
EXCHANGE [SUB]PARTITION



ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE [SUB]PARTITION statement have
different PRIMARY KEY constraints.

Action: Ensure that the two tables do not have PRIMARY KEY
constraints defined on any column or disable all PRIMARY KEY
constraints on both tables. Then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06925: CMX: disconnect during connect request

1 Answers  


ORA-32167: No payload set on the Message

1 Answers  


ORA-03230: segment only contains string blocks of unused space above high water mark

1 Answers  


PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements

1 Answers  


TNS-00043: The CMANAGER has active connections, do you still want to stop it (y/n)?

1 Answers  






QSM-02161: see the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled

1 Answers  


NNL-00023: SET command is missing an argument

1 Answers  


NNO-00269: configuration database is version string, server requires at least version string

1 Answers  


PLS-00377: internal type PLS_INTEGER is not included in this release of PL/SQL

1 Answers  


RMAN-06594: platform name 'string' specified in TO PLATFORM is not valid

1 Answers  


ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


ORA-27026: skgfrls: sbtend returned error

1 Answers  


Categories