ORA-30937: No schema definition for 'string' (namespace 'string') in parent 'string'
Cause : The schema definition for the parent node being processed does not allow for the specified child node in its content model. Note that any typecasting via xsi:type must occur before the schema definitions for the new type can be used.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Only insert elements and attributes declared in the schema. Check to make sure that xsi:type (if used) is specified first.
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.