ORA-26030: index string.string had string partitions made unusable due to:

Cause : A logical index error occurred on a partitioned index which * affected one or more index partitions, which are listed below * this message.

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

The affected index partitions will have to be re-built, or, the * entire index dropped and re-created.

update : 28-07-2017

ORA-26030 - index string.string had string partitions made unusable due to:
ORA-26030 - index string.string had string partitions made unusable due to:

  • ora-29655 : USING clause is incompatible with its supertype
  • ora-00568 : Maximum number of interrupt handlers exceeded
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-31050 : Access denied
  • ora-02335 : invalid datatype for cluster column
  • ora-24337 : statement handle not prepared
  • ora-32123 : Attribute number is out of range
  • ora-30475 : feature not enabled: string
  • ora-02174 : Missing required thread number
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-07721 : scgcm: not enough OS resource to obtain system enqueue
  • ora-19653 : cannot switch to older file incarnation
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-29267 : illegal call
  • ora-00154 : protocol error in transaction monitor
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-01301 : error writing to file during flat file build
  • ora-03008 : parameter COMPATIBLE >= string needed for string
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • ora-28542 : Error in reading HS init file
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-07708 : sksaprs: tape label name buffer too small
  • ora-12640 : Authentication adapter initialization failed
  • ora-23607 : invalid column "string"
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-16771 : failover to a physical standby database failed
  • ora-15068 : maximum number of diskgroups string already mounted
  • ora-22818 : subquery expressions not allowed here
  • 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.