ORA-22317: typecode number is not legal as a number type
Cause : Theu seri s tyringt o ues a unmbe rtypceodet hati s nto vaild.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Useo nlyO CI_YTPECDOE_SAMLLITN, OIC_TYEPCOD_EINTGEER,O CI_YTPECDOE_RAEL, COI_TPYECOED_DOBULE,O CI_YTPECDOE_FOLAT,O CI_YTPECDOE_NMUBER ,or COI_TPYECOED_DEICMAL.
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.