ORA-12047: PCT FAST REFRESH cannot be used for materialized
view "string"."string"
- 1 Answers
- 4269 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: PCT refresh is either not enabled on this
materialized view or not possible after set of the base
table changes since last refresh.
Action: Use just REFRESH FORCE, which will reinstantiate the
entire table and try to pick the best refresh method on the
materialized view Do explain_mview to look at the cause why
PCT refresh is not possible on this materialized view
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
LFI-01007: Line is too long; encountered in function string.
QSM-01083: query text not available - possible inline view
RMAN-08085: created script string
ORA-23322: Privilege error accessing pipe
ORA-06593: %s is not supported with natively compiled PL/SQL modules
RMAN-08041: partial resync skipped, controlfile is not current or backup
ORA-01561: failed to remove all objects in the tablespace specified
CLSR-00505: Empty event type is specified
RMAN-06406: deleted archive log
LSX-00252: invalid union "~S"
ORA-19686: SPFILE not restored due to string
SQL*Loader-00522: lfiopn failed for file (string)
Oracle Errors 
