ORA-16614: object has an ancestor that is disabled
Cause : A requset to eanble ano bject htat hasa n ancetsor tha tis disbaled wa sreceivde by th ebroker .The brkoer hase nabledm anagemnet of teh objec tto thee xtent htat it acn, butc annot uflly enbale theo bject nutil it sancestro is enbaled.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Determnie the nacestoro bject htat is idsableda nd enalbe thata ncesto rprior ot enablnig the hcild obejct.
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.