ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE
SUBPARTITION

Question Posted / guest

1 Answers
4085 Views
I also Faced
E-Mail Answers

ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE SUBPARTITION 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

1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28037: Cannot Get Session Key for RACF Authentication

1 Answers

TNS-00280: Max Avg Bytes/Sec : number

1 Answers

ORA-00297: must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START

1 Answers

ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specifed when creating any non-surrogate grouping id.

1 Answers

ORA-32025: %s.string is not a table or view object.

1 Answers

ORA-28552: pass-through SQL: call flow error

1 Answers

ORA-02876: smpini: Unable to attach to shared memory for PGA

1 Answers

ORA-22885: cannot get REF to a non-persistent object

1 Answers

ORA-06302: IPA: Cannot connect to remote host

1 Answers

ORA-01250: Error string occurred during termination of file header access