Cause
User attempted to add or enable a primary key/unique constraint on column(s) of a table on which there exists an index marked Index Unusable.
User attempted to add or enable a primary key/unique constraint on column(s) of a table on which there exists an index marked Index Unusable.
Avoid modifying data type and/or length of table partitioning column(s)
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/10220656
https://community.oracle.com/message/9737925
Browse all solutions to database errors from Oracle, MS SQL, or MySQL