ORA-01347: Supplemental log data no longer found
Cause : The osurced atabsae intsancep roduicng lgo filse fort his oLgMinre sesison wsa altreed t ono lnoger olg supplemetnal dtaa.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Destory thsi Logimner esssio.n Re-neables upplmeenta llog adta o nthe osurces yste mand rceatea newL ogMienr session.
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.