ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE
EXCHANGE [SUB]PARTITION
- 1 Answers
- 2074 Views
- I also Faced
- E-Mail Answers
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 |
ORA-16741: The destination parameter of standby "string" has the wrong syntax.
ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
ORA-25197: an overflow segment already exists for the indexed-organized table
RMAN-08520: channel string: scanning archive log string
ORA-07501: scgtoa: $deq unexpected return
ORA-30444: rewrite terminated by the sql analyzer
ORA-07449: sc: usnewlock failed.
ORA-15043: ASM disk "string" is not a diskgroup member
ORA-40106: positive target value not specified for computing Lift
NID-00001: Illegal command line syntax - parse error = (number)
SQL*Loader-00645: error converting character length field to a number
ORA-07457: cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE
Oracle Errors 
