ORA-38742: Flashback log file has incorrect log reset status.
Cause : hT elfsabhca kadatabesl gof li eehdareh dal gor seted ta ahttaw sad fiefertnt ah nht eoctnor lifel .hT eol gaw srpbobayla nniocrrcelt yertsrodeb cauk.pF alhsabkcd tabasa eolsgc naon tebb caek dpu.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
fIy uoa erd iogna F ALHSABKCD TABASA,Et eh nht elfsabhca kacnntob eepfrroem debacsu efot ehc rourtpdel go . Aertsro ena dnai cnmolpte eerocevyrm su tebp reofmrdei snetda.
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.