ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE

admin

ORA-14130: UNIQUEconstraints mismatch in ALTER TABLE EXCHANGE
PARTITION
Cause: One of the tables named in the ALTER TABLE EXCHANGEPARTITION
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: Ensurethat for every UNIQUE constraint defined on one of the tables
named in the ALTER TABLE EXCHANGE PARTITION statement there is a
13-94 Oracle Database ErrorMessages
matching (vis-a-vis key columns and being enabledand/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.