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-05-2017
ORA-26030

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-06560 : pos, string, is negative or larger than the buffer size, string
  • ora-06533 : Subscript beyond count
  • ora-28335 : referenced or referencing FK constraint column cannot be encrypted
  • ora-26738 : %s 'string' is not empty
  • ora-02234 : changes to this table are already logged
  • ora-12715 : invalid character set specified
  • ora-16701 : generic resource guard request failed
  • ora-06024 : NETASY: VTM error
  • ora-16243 : paging out string bytes of memory to disk
  • ora-28665 : table and partition must have same compression attribute
  • ora-31206 : DBMS_LDAP: PL/SQL - Invalid LDAP search scope.
  • ora-01160 : file is not a string
  • ora-03283 : specified datafile string does not exist
  • ora-13802 : failed to purge SQL Tuning Base entry from sql$
  • ora-29283 : invalid file operation
  • ora-40283 : missing cost matrix
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-28020 : IDENTIFIED GLOBALLY already specified
  • ora-04076 : invalid NEW or OLD specification
  • ora-24015 : cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
  • ora-19669 : proxy copy functions cannot be run on DISK channel
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-02066 : missing or invalid DISPATCHERS text
  • ora-07549 : sftopn: $OPEN failure
  • ora-16504 : the Data Guard configuration already exists
  • ora-07823 : sspsqr: $QIO failure
  • ora-28655 : Alter table add overflow syntax error
  • ora-40254 : priors cannot be specified for one-class models
  • ora-14017 : partition bound list contains too many elements
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • 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.