ORA-22898: existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
Cause : Table mentioned in the referential integrity constraint is different from the scope table of the REF column.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specify the scope table of the REF column in the referential integrity constraint and then retry the operation.
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.