Database Error Messages

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

OCI-32322

PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs

Cause

A table join dependent on another table on which PCT refresh is enabled has changed


Action

Use REFRESH FORCE which will pick the best possible refresh method on the materialized view