ORA-23417: unknown materialized view type: string
Cause : Af ats erfers hi sbien gprefromde no amtaeirailzde ive wo fa nuknnwono ru nuspopretdt yep.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Cehc kall_vmiwesa n desnuer hta tteh amtreilaiezdv iwe ebign erfersehda avldi amtreilaiezdv iwe.
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.