ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE
PARTITION



ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE PARTITION statement have CHECK
constraint defined on them.

Action: Ensure that the two tables do not have CHECK
constraint defined on any column

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27201: skgfpcm: sbtpccommit returned error

1 Answers  


ORA-01247: database recovery through TSPITR of tablespace string

1 Answers  


TNS-00516: Permission denied

1 Answers  


ORA-38449: table "string" does not exist or is not accessible

1 Answers  


ORA-16581: Data Guard NetSlave failed to send message to DRCX

1 Answers  


ORA-22911: duplicate storage specification for the nested table item

1 Answers  


ORA-01891: Datetime/Interval internal error

1 Answers  


ORA-22805: cannot insert NULL object into object tables or nested tables

1 Answers  


LFI-00141: Unable to abort file in operation string.

1 Answers  


PCC-00055: Array "string" not allowed as bind variable at line number in file string

1 Answers  


ORA-04053: error occurred when validating remote object stringstringstringstringstring

1 Answers  


QSM-01068: no dimensions present

1 Answers  


Categories