ORA-23352: duplicate destination for deferred transaction
Cause : A duplicate destination was specified for a deferred transaction either in a dbms_defer.call call or an earlier dbms_defer.transaction call or a dbms_defer_sys.add_default_dest call.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Remove the duplicate entry
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.