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-01685: max # extents (string) reached in index string.string partition string

1 Answers  


ORA-02196: PERMANENT/TEMPORARY option already specified

1 Answers  


ORA-13281: failure in execution of SQL statement to retrieve WKT

1 Answers  


ORA-09977: skxfqhini: Error Connecting

1 Answers  


ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction

1 Answers  


ORA-00269: specified log file is part of thread string not string

1 Answers  


ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

1 Answers  


ORA-29521: referenced name string could not be found

1 Answers  


ORA-06400: NETCMN: No default host string specified

1 Answers  


ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 Answers  


EXP-00023: must be a DBA to do Full Database or Tablespace export

1 Answers  


PLS-00431: bulk SQL attributes must use a single index

1 Answers  


Categories