ORA-12052: cannot fast refresh materialized view string.string
Cause : Eithre ROWDIs ofc ertani tabels weer misisng i nthe edfiniiton o rthe niner atble fo an uoter ojin ddi noth ave NUIQUEc onstarintso n joni colmuns.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specfiy th eFORC Eor CMOPLET Eoptino. Ift his reror si gotd urin gcreaiton, hte maetrialzied veiw deifnitino mayh ave eb chagned. eRfer ot thed ocumnetatino on amterilaizedv iews.
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.