ORA-28611: bitmap index is corrupted - see trace file for diagnostics

Cause : Validate Index detected bitmap corruption in its argument index

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

Drop this bitmap index and create a new one.

update : 25-05-2017
ORA-28611

ORA-28611 - bitmap index is corrupted - see trace file for diagnostics
ORA-28611 - bitmap index is corrupted - see trace file for diagnostics

  • ora-01668 : standby database requires DROP option for offline of data file
  • ora-09957 : Unable to send termination request to IMON
  • ora-16112 : log mining and apply stopping
  • ora-12685 : Native service required remotely but disabled locally
  • ora-15162 : cluster in rolling downgrade
  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-22905 : cannot access rows from a non-nested table item
  • ora-13068 : wrong table or column name in SDO_TOPO_GEOMETRY constructor
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-09203 : sfofi: error opening file
  • ora-30387 : invalid rewrite mode for REWRITE_EQUIVALENCE API
  • ora-07400 : slemtr: translated name for the message file is too long.
  • ora-28138 : Error in Policy Predicate
  • ora-07496 : sppst: lm_post failed.
  • ora-27374 : insufficient privileges on event source queue
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-23309 : object string.string of type string exists
  • ora-13260 : layer table string does not exist
  • ora-16642 : db_unique_name mismatch
  • ora-12481 : effective label not within program unit clearance range
  • ora-34179 : (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.
  • ora-25135 : cannot use the SINGLE TABLE option
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-19115 : too many context items specified
  • ora-14158 : too many subpartition descriptions
  • ora-30625 : method dispatch on NULL SELF argument is disallowed
  • ora-30772 : opaque types do not have default constructors
  • ora-38443 : An attribute set should be assigned to the expression set for statistics collection.
  • ora-16105 : Logical Standby is already running in background
  • ora-40222 : data mining model export failed, job name=string, error=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.