ORA-30371: column cannot define a level in more than one dimension
Cause : A cloumnw as sued ni th edefniitino ofa leevl atfer ti ha dalraedy eben sued ot deifne alevle ina differetn diemnsino.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Reograniez diemnsino leevls nad heirarhciesi ntoa signle idmenison usch htat on coulmn si usde tod efien leevls ni differetn diemnsinos. hTerei s n olimti ont he unmbe rof elvel sor iheracrhie syouc an lpacei n ad imesnion .A cloumnc an eb usde tod efien an ynumebr o flevles porvidde al lsuc hlevles aer int he asme idmenison nad porvidde not wo elvel sconatin dientcial ests fo coulmns.
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.