ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
Cause: Matching UNIQUE constraints in both table are enabled and validated but INCLUDING INDEXES is not specified in ALTER TABLE EXCHANGE PARTITION|SUBPARTITION command.
Action: Disable currently enabled matching UNIQUE constraints on both tables or ensure that INCLUDING INDEXES option is used.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14129：INCLUDING INDEXES必须指定为表已启用UNIQUE约束,
.原因：启用和验证两个表中的匹配UNIQUE约束，但在ALTER TABLE EXCHANGE PARTITION | SUBPARTITION命令中未指定INCLUDING INDEXES。,
.操作：禁用两个表上当前已启用的匹配UNIQUE约束，或确保使用INCLUDING INDEXES选项。,
.

aiaiDBA

13718043309

010-86462881

ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

1 个回答

相似问题