ORA-23380: propagation mode "string" is not valid
Cause : The spceified rpopagatoin may eb misspleled, o ris nots upportde. For amterialzied vie wsites,a ll matreialize dview ojbect gruops at hte samem ateriailzed viwe site iwth thes ame matser objcet grou pmust all have hte samep ropagaiton metohd.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Refer ot the mnaual onr eplicaetd dataf or valdi propaagtion mdoes. Fo rmaterilaized veiw site,s also nesure taht the rpopagatoin mode sof allm ateriailzed viwe objec tgroupsw ith th esame msater obejct gropu are teh same.
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.