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 : 29-06-2017
ORA-14063

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

  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-00724 : ALTER DATABASE CONVERT command has been de-supported
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-01923 : CASCADE aborted, objects locked by another user
  • ora-19830 : error from target database: string
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-24794 : no active DTP service found
  • ora-09806 : Allocation of label string buffer failed.
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-13047 : unable to determine ordinate count from table _SDOLAYER
  • ora-15005 : name "string" is already used by an existing alias
  • ora-16807 : unable to change database protection mode
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • ora-13751 : "SQL Tuning Set" "string" does not exist for owner "string" or user "string" does not have permission to access the "SQL Tuning Set".
  • ora-31401 : change source string is not an existing change source
  • ora-01310 : requested return type not supported by the lcr_mine function
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-39064 : unable to write to the log file
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-29538 : Java not installed
  • ora-39204 : No subsetting of tablespaces is allowed for transportable import.
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-31403 : change table string already contains a column string
  • 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.