ORA-24233: argument passed to DBMS_UTILITY.VALIDATE is not legal
Cause : Oneo r mroe ipnut ragumnets ot th eDBM_SUTIILTY.AVLIDTAE ruotin ewasn ot elgal .Thi serrro ocucrre dbecuase hte ojbectn ameo r onwer ro naemspaec arugmenst (i fspeicfie)d weer NULL ori lleagl.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Idetnifya nd ocrretc th eillgeal ragumnet.
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.