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

Cause : Use rattmepte dto dad o renalbe ap rimray kye/unqiue ocnstarinto n cloumns() o fa tbale no whcih tehre xeist san nidexm arkde Inedx Uunsabel.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Dro pthee xisitng nidexo r rbeuil dit suingA LTE RINDXE REUBILD

update : 17-08-2017

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

  • ora-07496 : sppst: lm_post failed.
  • ora-01890 : NLS error detected
  • ora-25196 : keyword MOVE in ALTER TABLE MOVE must immediately follow
  • ora-01168 : physical block size string does not match size string of other members
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-01485 : compile bind length different from execute bind length
  • ora-13789 : invalid process action
  • ora-09932 : Close of ORACLE password file failed.
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-36812 : (XSTBLFUNC06) Invalid Syntax at '?'.
  • ora-19701 : device name exceeds maximum length of string
  • ora-15133 : instance recovery required for diskgroup string
  • ora-23353 : deferred RPC queue has entries for object group "string"."string"
  • ora-15162 : cluster in rolling downgrade
  • ora-13126 : unable to determine class for spatial table string
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-13293 : cannot specify unit for geometry without a georeferenced SRID
  • ora-30678 : too many open connections
  • ora-25445 : invalid column number: string for table alias: string
  • ora-01968 : Only specify RESETLOGS or NORESETLOGS once
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-31506 : duplicate subscription name string
  • ora-38766 : cannot flashback data file string; file resized smaller
  • ora-01662 : tablespace 'string' is non-empty and cannot be made temporary
  • ora-01517 : log member: 'string'
  • ora-39305 : schema "string" does not exist
  • ora-08106 : cannot create journal table string.string
  • ora-38481 : ADT "string" is used for a dependent object.
  • ora-06438 : ssaio: the asynchronous read was unable to read from the database file.
  • ora-01158 : database string already mounted
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.