ORA-22919: dangling REF error or lock object failed for no wait request
Cause : hT ereor roclu debo eno fht eofllwoni.gT eho jbce tocrrseopdnni gott ehR FEd eo son txesi trot eho jbce taw solkcdeb ynatoeh rsurea dnt ehl co kiwhtn woia teruqse taflide.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
nEusert ah tht eER Favul esip iotnni gota nxesiitgno jbce troi sseua l co keruqse tiwhtuo tht eonawtio tpoi.n
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.