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