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

DRG-10504: primary key is required when using the DETAIL_DATASTORE

1 Answers  


O2F-00318: Error writing to the OUTTYPE file

1 Answers  


ORA-07633: smsdbp: illegal protection value

1 Answers  


RMAN-08041: partial resync skipped, controlfile is not current or backup

1 Answers  


TNS-04141: Unable to find CMAN.ORA file.

1 Answers  






ORA-24364: internal error while padding blanks

1 Answers  


NNL-00007: server responded with an error

1 Answers  


RMAN-06532: redundancy count must be greater than zero

1 Answers  


IMP-00083: dump file does not contain an incremental export

1 Answers  


NNC-00416: user callback function returned error number string

1 Answers  


RMAN-06116: cannot crosscheck unavailable object

1 Answers  


ORA-28577: argument string of external procedure string has unsupported datatype string

1 Answers  


Categories