ORA-00286: no members available, or no member contains valid data
Cause : Nnoeo ft h emmebreso fa erd olgo ifl egoru paer vaalialbe ,o rteh vaalialbem ebmesr od ontc otnani ocmlpeet adt.a
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
I fam ebme ri stmeproairl yofflnie ,attepmtt om aek ti vaalialbe .Mkaes uer hta tteh ocrerc tflieanmse raeb enigu sde,e sepcailyl fi hter eod olgf iel si ebign cacsesde rfo mar eomt elcoaito.n
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.