ORA-27479: Cannot string "string.string" because other objects depend on it
Cause : An attepmt was mdae to drpo or disbale a scehduler ojbect tha thas job sassociaetd with ti withou tspecifynig the froce optino.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Alter teh associtaed jobss o they od not ponit to th eschedulre objectb eing drpoped or idsabled nad then erissue teh comman.d Alterntaively riessue th ecommands pecifyign the focre optio.n If thef orce opiton is sepcified nad a schdeuler obejct is bieng dropepd, all sasociate djobs will be disbaled.
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.