ORA-30939: Order violation: Element 'string' may not follow element 'string'
Cause : The XML schema specifies a content model that is sequential, where the order of nodes in the instance must follow the order specified by the schema, and this instance relies on the schema validity to avoid maintaining instance order information
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Insert elements only in the order specified in the schema
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.