Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00108: TNS_ADMIN not defined

1 Answers  


PCC-02437: Expecting an expression having binary integral type

1 Answers  


ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree

1 Answers  


DRG-10501: invalid stopword: string

1 Answers  


TNS-04234: Trace Assistant WARNING: won't decode TTC

1 Answers  






ORA-02347: cannot grant privileges on columns of an object table

1 Answers  


ORA-31100: XDB Locking Internal Error

1 Answers  


ORA-25182: feature not currently available for index-organized tables

1 Answers  


ORA-02354: error in exporting/importing data string

1 Answers  


SQL*Loader-00487: COUNT clause required for collection string

1 Answers  


ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

1 Answers  


ORA-02195: Attempt to create string object in a string tablespace

1 Answers  






Categories