ORA-22857: cannot modify columns of object tables
Cause : An attempt was made to alter the object table by modifing existing columns. An object table cannot be altered to modify existing columns since it is based on an object type. The table definition must be in sync with the corresponding type.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Create a new type with the desired attribute types and use it to create an object table. The new object table will have the desired columns.
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.