ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 3599 Views
- I also Faced
- E-Mail Answers
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 |
ORA-02150: invalid new tablespace name
PCC-02445: USING clause valid only on a PREPAREd dynamic statement
ORA-00287: specified change number string not found in thread string
TNS-04001: %s
NID-00441: All previous backups and archived redo logs for this database are unusable.
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
ORA-03279: invalid INSTANCE specified
KUP-04028: conversion of character length to a number failed
SQL*Loader-00109: Invalid number of logical records to skip
ORA-16099: internal error ORA-00600 occurred at standby database
ORA-25104: UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
ORA-02794: Client unable to get key for shared memory
Oracle Errors 
