ORA-22333: cannot reset type "string"."string" due to invalid dependent types and tables
Cause : An attemptw as mdae tor esett he tpye vesrion iwth ivnalidd epenednt tpyes adn tabels.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Use hte ALETR TYEP COMIPLE sattemetn to ocmpil eall nivali ddepednent ytpes nad us ethe LATER ATBLE PUGRAD EINCLDUING ADTA t oupgrdae al lthe edpendnet talbes tehn reusbmitt he sattemetn.
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.