ORA-12047: PCT FAST REFRESH cannot be used for materialized
view "string"."string"
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 |
DRG-11814: See Other
NNL-00871: Updates refused, name is a topology name: number
RMAN-06290: Report of database schema
PLS-00417: unable to resolve "string" as a column
ORA-01230: cannot make read only - file string is offline
ORA-01982: invalid auditing option for tables
IMG-00581: output format does not support the specified contentFormat
QSM-01023: materialized view, string, has GRANT errors
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
ORA-30355: materialized view container does not exist
ORA-07443: function string not found
TNS-00105: Could not initialize tracing