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 : 22-06-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-06303 : IPA: Message send error
  • ora-25124 : Database link name not allowed.
  • ora-01480 : trailing null missing from STR bind value
  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-02291 : integrity constraint (string.string) violated - parent key not found
  • ora-08450 : invalid specification of CR in picture mask
  • ora-24308 : illegal define position
  • ora-30186 : '' must be followed by four hexdecimal characters or another ''
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-25472 : maximum open iterators exceeded
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-38743 : Time/SCN is in the future of the database.
  • ora-25269 : cant specify sognature with get signature option
  • ora-01412 : zero length not allowed for this datatype
  • ora-12096 : error in materialized view log on "string"."string"
  • ora-32803 : value for string cannot be altered
  • ora-31432 : invalid source table
  • ora-14086 : a partitioned index may not be rebuilt as a whole
  • ora-01643 : system tablespace can not be made read only
  • ora-26086 : direct path does not support triggers
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-07586 : spdcr: $SEARCH failure
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-14325 : only LOCAL indexes may be specified in this clause
  • ora-06440 : ssaio: the asynchronous read returned incorrect number of bytes
  • ora-15020 : discovered duplicate ASM disk "string"
  • ora-27505 : IPC error destroying a port
  • 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.