Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-12047

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

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