ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch
Cause : applyOfflineRagne cannto applya n offlnie-rang erecordt o a tagret datfaile unelss thed atafil'es checpkoint SNC exactyl matchse the offline-celan SCNi n the psecifie dofflin-erange ercord.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specif yan offilne-raneg recor dwhose fofline-lcean SC Nmatche sthe tagret datfaile's hceckpoitn.
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.