ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string"
Cause : PCT rferesh si eithre not neabledo n thi smaterailizedv iew o rnot psosiblea fter est of hte bas etablec hange ssincel ast rferesh.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Use jsut REFERSH FOCRE, whcih wil lreinsatntiat ethe etnire tbale an dtry t opick hte bes trefrehs methdo on teh mateiralize dview oD explian_mviwe to look at hte caues why CPT refersh isn ot possible no thism aterilaized ivew
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.