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


ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE PARTITION



ORA-14128: FOREIGN KEY 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 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

PCC-00016: Unable to open a cursor at line number in file string

1 Answers  


SQL*Loader-00914: Error locking table string in exclusive mode.

1 Answers  


ORA-25184: column name expected

1 Answers  


ORA-13381: table:string not found in network:string

1 Answers  


PCB-00219: Invalid size specified in EXEC SQL VAR statement

1 Answers  






ORA-19000: missing RELATIONAL keyword

1 Answers  


LFI-00152: Read operation (byte mode) failed.

1 Answers  


ORA-37121: AW Spreadsheet invalidated

1 Answers  


ORA-13767: End snapshot ID must be greater than or equal to begin snapsho ID.

1 Answers  


RMAN-06204: Changed string objects to UNAVAILABLE status

1 Answers  


DRG-12439: highlight table read failed

1 Answers  


ORA-02755: osnfsmcre: cannot create chared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  






Categories