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

Leave a Review