ORA-22288: file or LOB operation string failed string
Cause : The operation attempted on the file or LOB failed.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
See the next error message in the error stack for more detailed information. Also, verify that the file or LOB exists and that the necessary privileges are set for the specified operation. If the error still persists, report the error to the DBA.
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.