ORA-28604: table too fragmented to build bitmap index (string,string,string)

Cause : The atble ahs on eor mroe blcoks taht execed teh maxmium nmuber fo row sexpetced wehn craetinga bitamp inedx. Tihs isp robalby du eto dleetedr ows.T he vlaues ni them essaeg are :(dat abloc kaddrses, solt nubmer fuond, amximu mslota llowde)

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

Defrgamentt he tbale o rbloc(ks). sUe th evaluse in hte message ot detreminet he FRIST bolck affecte.d (Three ma ybe ohters).

update : 26-04-2017
ORA-28604

ORA-28604 - table too fragmented to build bitmap index (string,string,string)
ORA-28604 - table too fragmented to build bitmap index (string,string,string)

  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-38956 : Target platform string not cross platform compliant
  • ora-27149 : assignment out of range
  • ora-22338 : must specify CASCADE INCLUDING DATA when altering the final property
  • ora-29338 : datafile string is in an undesired state (string, string)
  • ora-07593 : ssprprv: Error release privileges
  • ora-15060 : template "string" does not exist
  • ora-31413 : change set string is currently being advanced
  • ora-00166 : remote/local nesting level is too deep
  • ora-13349 : polygon boundary crosses itself
  • ora-24354 : number fetched too large to fit in COBOL display type buffer.
  • ora-01167 : two files are the same file/group number or the same file
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • ora-08180 : no snapshot found based on specified time
  • ora-19112 : error raised during evaluation: string
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-29853 : keyword UNIQUE may not be used in creating domain indexes
  • ora-19035 : Invalid select item of the query in newContextFromHierarchy()
  • ora-27152 : attempt to post process failed
  • ora-28523 : ORACLE and heterogeneous agent are incompatible versions
  • ora-02465 : Inappropriate use of the HASH IS option
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-31483 : cannot have spaces in the parameter string
  • ora-01235 : END BACKUP failed for string file(s) and succeeded for string
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-27006 : sbtremove returned error
  • ora-02762 : file number to be cancelled is greater than the maximum.
  • 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.