重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-14064: Index with Unusable partition exists [打印本页]

---

作者: admin    时间: 2016-8-18 10:00
标题: ORA-14064: Index with Unusable partition exists
ORA-14064: Index withUnusable partition exists on unique/primary constraint key
Cause: User attempted to add or enable a primary key/uniqueconstraint on
column(s) of a table on which there exists an index one or more partitions ofwhich
are marked Index Unusable.
Action: Dropthe existing index or rebuild unusable partitions it using ALTER
INDEX REBUILD PARTITION

---

欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2