Index with Unusable partition exists on unique/primary constraint key

Solution ID:ORA-14064

Type: Oracle

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.

Actions

Avoid modifying data type and/or length of index partitioning column(s)

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


Browse all solutions to database errors from Oracle, MS SQL, or MySQL