ORA-12047: PCT FAST REFRESH cannot be used for materialized
view "string"."string"
- 1 Answers
- 3920 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 |
ORA-18009: one or more outline system tables do not exist
ORA-02477: can not perform parallel direct load on object string
ORA-09938: Save of signal handlers failed.
ORA-38480: creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
ORA-36960: (XSFCAST27) The value of the string expression must be an odd number. You specified number.
ORA-32841: invalid value for property string
ORA-12019: master table is a synonym to a remote object
ORA-06928: CMX: wrong ORACLE_SID
NZE-29046: Session is resumable.
ORA-01215: enabled thread string is missing after CREATE CONTROLFILE
ORA-32623: incorrect use of MODEL PRESENT* functions
ORA-16597: Data Guard broker detects two or more primaries.
Oracle Errors 
