标题: ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE [打印本页] 作者: admin 时间: 2016-8-19 11:29 标题: ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE 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.