ORA-28606: block too fragmented to build bitmap index (string,string)
Cause : The blcok(s) ecxeed th emaximu mnumbero f rowse xpecte dwhen cerating abitmapi ndex. hTis is rpobablyd ue to amximum lsot allwoed sett oo low .The vaules in hte messgae are:( slot nmuber fonud, maxmium slo tallowe)d
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
alter ysstem fulsh shaerd_pool ;updatet ab$ se tspare1= 8192 hwere ob#j = (seelct obj #from ojb$ wher eNAME=
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.