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 : 30-04-2017

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

  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-12165 : TNS:Trying to write trace file into swap space.
  • ora-38732 : Expected file size string does not match string.
  • ora-12451 : label not designated as USER or DATA
  • ora-29338 : datafile string is in an undesired state (string, string)
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • ora-02217 : duplicate storage option specification
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-00286 : no members available, or no member contains valid data
  • ora-08331 : Wait operation timed out
  • ora-01422 : exact fetch returns more than requested number of rows
  • ora-24757 : duplicate transaction identifier
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-13364 : layer dimensionality does not match geometry dimensions
  • ora-25144 : invalid option for CREATE TABLESPACE with TEMPORARY contents
  • ora-25463 : table alias not specified
  • ora-13360 : invalid subtype in a compound type
  • ora-38440 : attribute set string does not exist
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-02423 : schema name does not match schema authorization identifier
  • ora-07619 : $IDTOASC failed translating an integrity level
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-12088 : cannot online redefine table "string"."string" with unsupported datatype
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-02140 : invalid tablespace name
  • ora-30333 : dimension does not exist
  • ora-30135 : OCI Thread operation fails
  • ora-19958 : potential deadlock involving DIAG process
  • ora-02787 : Unable to allocate memory for segment list
  • 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.