ORA-14063: Unusable index exists on unique/primary
constraint key



ORA-14063: Unusable index 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 marked Index Unusable.

Action: Drop the existing index or rebuild it using ALTER
INDEX REBUILD

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00263: Navigator: Request Failed

1 Answers  


PLS-00594: the SELF parameter can be declared only as IN or as IN OUT

2 Answers  


ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 Answers  


KUP-04041: error generating full file name for string in string

1 Answers  


ORA-02789: Maximum number of files reached

1 Answers  






ORA-25239: message ID not supplied when dequeuing from exception queue string.string

1 Answers  


ORA-01898: too many precision specifiers

1 Answers  


ORA-02729: osncon: driver not in osntab

1 Answers  


ORA-22304: input type is not an object type

1 Answers  


ORA-23397: global name "string" does not match database link name "string"

1 Answers  


NID-00403: DBNEWID - Completed with validation errors.

1 Answers  


ORA-09773: osnmgetdatmsg: message from host had incorrect message type

1 Answers  


Categories