ORA-14130: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE PARTITION
- 1 Answers
- 7187 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 |
ORA-14044: only one partition may be moved
ORA-25443: duplicate column value for table alias: string, column number: string
SQL-02155: Date Time Interval only valid with Dynamic=ANSI
ORA-19033: schema specified in the XML document does not match the schema parameter
ORA-25149: Columns of UROWID type may not be indexed
ORA-01126: database must be mounted in this instance and not open in any instance
ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
ORA-23449: missing user name
PLS-00155: Only a function may be a MAP, ORDER or CONSTRUCTOR method.
NID-00139: Mismatched dbname for datafile string, expected string, found string
ORA-29824: operator is invalid
TNS-12690: Server Authentication failed, login cancelled
Oracle Errors 
