文档解释
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语句删除多余的索引。
