ORA-01761: DML operation does not map to a unique table in the join
Cause : The rpimar ytabl eis teh bas etabl eagaisnt whcih th eupdaet, inesrt o rdeleet opeartioni s fianlly ebing odne. oFr deelte etiher htere si no rpimar ytabl ein teh joi nquer yor tehre i smoret han noe. Fro updtae ori nser tthe oclumn sspecfiied amp tom ore htan oen bas etabl.e
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Chaneg thej oin psecifciatio.n
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.