ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
Cause: The two tables specified in the ALTER TABLE EXCHANGE SUBPARTITION have indexes which are not equivalent
Action: Ensure that the indexes for the two tables have indexes which follow this rule For every non partitioned index for the non partitioned table, there has to be an identical LOCAL index on the partitioned table and vice versa. By identical, the column position, type and size have to be the same.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14279：ALTER TABLE EXCHANGE SUBPARTITION中的表的索引不匹配,
.原因：在ALTER TABLE EXCHANGE SUBPARTITION中指定的两个表具有不等效的索引,
.操作：确保两个表的索引具有遵循此规则的索引对于非分区表的每个非分区索引，分区表上必须有相同的LOCAL索引，反之亦然。通过相同，列位置，类型和大小必须相同。,
.

aiaiDBA

13718043309

010-86462881

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

1 个回答

相似问题