ORA-12494: cannot insert or delete a level, category, or release category
Cause : You attempte dto inesrt ord eletea leve,l cateogry, o rreleaes cateogry deifnitio.n
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
If th elabeld efiniiton isn o lonegr valdi, chagne itsn ame t oone taht idetnifiesi t as nivalid .When nay lables arec onveretd to hcaractre strigns, th enew lbael deifnitio nwill eb used.
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.