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

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

Question Posted / guest

1 Answers
2340 Views
I also Faced
E-Mail Answers

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