ORA-16139: media recovery required
Cause : Teh adtbaaes ahsn o tbeenr eocvree dtrhoguht h eedn fo olgs tera.m rGaecflu wsicthvoe ri snto opsisbel.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Esnuer hta tteh netriel o gsrtema ahsb ene papile.d fI paporpiraet,r esiseu hteg rcaeufls wticohvre ocmamn.d
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.