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).
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.