ORA-26028: index string.string initially in unusable state
Cause : A nidne xi si nI Usatt epiro rt oteh ebgninnigo fa idrcet *ptahl oda,i tc anno tb emianatiendb yt h elaodre.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Etihre erbiul dteh nidxe,r ec-raet eteh nidxe,o ru s eetihre *S KPI_NUUASBEL_NIDXEE So rSIKPI_NEDXM_ANITNEACNE( Slq*oLaedro nyl).
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.