Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 7928 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: One of the tables named in the ALTER TABLE EXCHANGE
PARTITION command has a UNIQUE constraint for which no
matching (vis-a-vis key columns) constraint is defined on
the other table or a matching constraint is defined on the
other table, but it differs from that defined on the first
table vis-a-vis being enabled and/or validated.
Action: Ensure that for every UNIQUE constraint defined on
one of the tables named in the ALTER TABLE EXCHANGE
PARTITION statement there is a matching (vis-a-vis key
columns and being enabled and/or validated) UNIQUE
constraint defined on the other table. If UNIQUE constrains
are enabled, UNIQUE constraints on the partitioned table
should be enforced using local indexes.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
RMAN-08155: printing stored global script: string
ORA-09926: Unable to set effective privilege set of the server
ORA-19921: maximum number of string rows exceeded
ORA-16591: unknown field "string" in document
NNO-00104: line string: syntax error, data ignored
QSM-02028: group by CUBE
ORA-38758: cannot flashback data file string; restored since last recovery
ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.
EXP-00038: Bad Hash cluster id in clu$
NNO-00120: line string: topology name "string" not allowed here
TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
NNL-00906: NOT A LEAF NAME responses sent: number
Oracle Errors 
