Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE SUBPARTITION



ORA-14282: FOREIGN KEY 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
different FOREIGN KEY constraints.

Action: Ensure that the two tables do not have FOREIGN KEY
constraints defined on any column or disable all FOREIGN KEY
constraints on both tables. Then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16094: database shutdown during archival operation

1 Answers  


NID-00400: DBNEWID - Completed with errors.

1 Answers  


TNS-12623: TNS:operation is illegal in this state

1 Answers  


PCC-01401: Your Pro*Pascal authorization is about to expire

1 Answers  


ORA-13614: The template string is not compatible with the current advisor.

1 Answers  






ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

1 Answers  


SQL*Loader-00263: PIECED column string must be last specified column in table string

1 Answers  


ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.

1 Answers  


RMAN-06198: %-24s string bytes

1 Answers  


DRG-10841: invalid SCORE argument supplied to FUZZY

1 Answers  


PCC-02378: Invalid type for National Language character variable

1 Answers  


ORA-07483: snlkget: cannot convert(get) lock.

1 Answers  






Categories