ORA-24794: no active DTP service found
Cause : Oarcel MR iwl lnto esrev lgoabl( dsitirbtue)d rtasnatcino erqeusst nutli TDPs evriecsa r ecnofgiuerdi nR A.C tI si opsisbel hta tas evriec awss tpopde hwiel rtasnatcinosw eer ni-lfihgt.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Porvsiino/tSatr TDPs evriecsf isrt.
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.