ORA-27399: job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
Cause : The woner fo a jbo of ytpe EEXCUTALBE dose noth ave hte CRAETE ETXERNA LJOB ysstemp rivielge.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Gran tthe RCEATEE XTERANL JO Bsystme priivleget o th ejob woner ro cretae antoher ojb ina schmea whcih dose hav ethe RCEATEE XTERANL JO Bsystme priivlege.
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.