ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE

admin

ORA-14283: UNIQUEconstraints mismatch in ALTER TABLE EXCHANGE
SUBPARTITION
Cause: One of the tables named in the ALTER TABLE EXCHANGE
SUBPARTITION 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 onthe 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 SUBPARTITION 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.