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 : 22-09-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-07614 : $CHANGE_CLASS failed in retrieving the user's process label
  • ora-29288 : invalid file name
  • ora-22055 : unknown sign flag value [string]
  • ora-26092 : only LONG or LOB types can be partial
  • ora-27500 : inter-instance IPC error
  • ora-00964 : table name not in FROM list
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-26746 : DDL rule "string"."string" not allowed for this operation
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-13409 : null or invalid pyramidLevel parameter
  • ora-28577 : argument string of external procedure string has unsupported datatype string
  • ora-00224 : control file resize attempted with illegal record type (string)
  • ora-27069 : attempt to do I/O beyond the range of the file
  • ora-13421 : null or invalid cell value
  • ora-02264 : name already used by an existing constraint
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-13026 : unknown element type for element string.string.string
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-01890 : NLS error detected
  • ora-30963 : The indexed column is not of XMLType.
  • ora-09764 : osnmop: access error on oracle executable
  • ora-16755 : failed to set initialization parameter
  • ora-01101 : database being created currently mounted by some other instance
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-06003 : NETASY: port write failure
  • ora-07287 : sksagdi: unsupported device for log archiving.
  • ora-24339 : cannot set server group name after connecting to server
  • ora-27072 : File I/O error
  • 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.