ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE SUBPARTITION
- 1 Answers
- 2493 Views
- I also Faced
- E-Mail Answers
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 |
ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group
PLS-00618: type mismatch found at 'string' between operands in a NULLIF expression
PLS-00614: creating a FINAL NOT INSTANTIABLE type
ORA-23341: user function required
RMAN-06452: %s package upgraded to version string
ORA-06401: NETCMN: invalid driver designator
PLS-00542: CLOB and NCLOB cannot use varying-width character sets in the server
ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
ORA-12657: No algorithms installed
ORA-12159: TNS:trace file not writeable
TNS-02519: no appropriate key-negotiation parameters
ORA-30011: Error simulated: psite=string, ptype=string
Oracle Errors 
