Oracle Error ORA-32322: PCT refresh of “string”.”string” not allowed the sequence of DMLs/PMOPs

Oracle Error Message

ORA-32322: PCT refresh of “string”.”string” not allowed the sequence of DMLs/PMOPs

Reason for the Error

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

Solution

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