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-02067: transaction or savepoint rollback required

1 Answers  


ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

1 Answers  


NNL-00254: Server-generated requests currently do not request forwarding

1 Answers  


NNL-00907: NOT ALLOWED responses sent: number

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  






PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


PCC-02202: No typedef name was given

1 Answers  


ORA-24348: Update or Delete without Where

1 Answers  


TNS-04069: Sleeping for number seconds...

1 Answers  


ORA-36990: (XSRELGID07) %a workspace object The level relation %1p should be dimensioned by a level dimension.

1 Answers  


ORA-19717: for non-OMF search the pattern must be specified

1 Answers  


Categories