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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14283：ALTER TABLE EXCHANGE SUBPARTITION中的UNIQUE约束不匹配,
.原因： ALTER TABLE EXCHANGE SUBPARTITION命令中命名的其中一个表具有UNIQUE约束，在该约束中，在其他表上未定义匹配（相对键列）约束，或者在另一个表上定义了匹配约束，但是它不同于在启用和/或验证的第一表上定义的。,
.操作：确保对于在ALTER TABLE EXCHANGE SUBPARTITION语句中命名的其中一个表上定义的每个UNIQUE约束，都存在在另一个表上定义的匹配（针对键列以及已启用和/或已验证）UNIQUE约束。如果启用UNIQUE约束，则应使用本地索引强制对分区表的UNIQUE约束。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题