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



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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25283: either agent's name or address needed for non-repudiation

1 Answers  


TNS-00536: Connection entered inappropriate state

1 Answers  


ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher

1 Answers  


ORA-32151: Environment not specified

1 Answers  


SQL*Loader-00122: Invalid skip_index_maintenance option

1 Answers  






ORA-01905: STORAGE keyword expected

1 Answers  


PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal

1 Answers  


ORA-29274: fixed-width multibyte character set not allowed for a URL

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


DRG-11218: malformed mail line, line string

1 Answers  


ORA-27048: skgfifi: file header information is invalid

1 Answers  


ORA-31010: XML element index string exceeds maximum insertion index string

1 Answers  


Categories