ORA-14064: Index with Unusable partition exists on unique/primary constraint key

ORA-14064: Index with Unusable partition exists on unique/primary constraint key
Cause: User attempted to add or enable a primary key/unique constraint on column(s) of a table on which there exists an index one or more partitions of which are marked Index Unusable.
Action: Drop the existing index or rebuild unusable partitions it using ALTER INDEX REBUILD PARTITION

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14064：具有不可用分区的索引存在于唯一/主约束密钥上,
.原因：用户尝试在存在索引的表的列上添加或启用主键/唯一约束，其中一个或多个分区标记为“索引不可用”。,
.操作：删除现有索引或使用ALTER INDEX REBUILD PARTITION重建不可用的分区,
.

aiaiDBA

13718043309

010-86462881

ORA-14064: Index with Unusable partition exists on unique/primary constraint key

1 个回答

相似问题