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

update : 26-09-2017
ORA-12047

ORA-12047 - PCT FAST REFRESH cannot be used for materialized view "string"."string"
ORA-12047 - PCT FAST REFRESH cannot be used for materialized view "string"."string"

  • ora-30977 : invalid Value Index option for XML Index
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-01227 : log string is inconsistent with other logs
  • ora-10655 : Segment can be shrunk
  • ora-26521 : rpc initialization error
  • ora-02301 : maximum number of OIDGENERATORS is 255
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-36910 : (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.
  • ora-29317 : datafile string does not exist
  • ora-02177 : Missing required group number
  • ora-30962 : inconsistent ODCI input arguments
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-30176 : invalid format code used in the format string
  • ora-30048 : Internal event for IMU auto-tuning
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-12708 : error while loading create database NLS parameter string
  • ora-16406 : Primary and standby database software version mismatch
  • ora-22817 : subquery not allowed in the default clause
  • ora-22153 : source variable-length array is not initialized
  • ora-16241 : Waiting for gap logfile (thread# string, sequence# string)
  • ora-27142 : could not create new process
  • ora-06537 : OUT bind variable bound to an IN position
  • ora-19020 : invalid dereference of XMLType columns
  • ora-02070 : database stringstring does not support string in this context
  • ora-30464 : no summaries exist
  • ora-14605 : Name missing for subpartition / lob segment in template
  • ora-06918 : CMX: T_NOEVENT during wait for read event
  • ora-28528 : Heterogeneous Services datatype conversion error
  • ora-13445 : GeoRaster metadata SRS error
  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    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.