ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION

文档解释

ORA-14283: UNIQUE constraints 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 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 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.

ORA-14283: 当使用ALTER TABLE EXCHANGE SUBPARTITION命令时，由于在子分区中指定的UNIQUE约束和接收子分区不匹配，发生UNIQUE约束不匹配错误。

官方解释

常见案例

正常处理方法及步骤

1.检查要替换子分区的UNIQUE约束是否同源子分区匹配。

2.使用CREATEUNIQUE INDEX语句在指定索引中创建相同的UNIQUE索引，以使其匹配源子分区。

3.在尝试完成子分区交换后，可以使用DROP INDEX语句删除多余的索引。