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



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

PCC-01004: In an EXEC statement at end-of-file

1 Answers  


TNS-12548: TNS:incomplete read or write

1 Answers  


ORA-01928: GRANT option not granted for all privileges

1 Answers  


QSM-02067: no partition key or PMARKER or join dependent expression in select list

1 Answers  


ORA-01755: Must specify an extent number or block number

1 Answers  






ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW

1 Answers  


ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

1 Answers  


LSX-00132: attribute "~1S" has invalid occurrences value "~2S"

1 Answers  


ORA-00332: archived log is too small - may be incompletely archived

1 Answers  


ORA-02723: osnpui: cannot send break signal

1 Answers  


ORA-32156: Cannot perform operation on stream

1 Answers  


ORA-04032: pga_aggregate_target must be set before switching to auto mode

1 Answers  


Categories