ORA-00278: log file 'string' no longer needed for this recovery
Cause : The specified redo log file is no longer needed for the current recovery.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
No action required. The archived redo log file may be removed from its current location to conserve disk space, if needed. However, the redo log file may still be required for another recovery session in the future.
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.