Oracle Solution for Error ora-32320

ORA-32320: REFRESH FAST of "string

"."string

" unsupported after container table PMOPs

What triggered the Error:

A Partition Maintenance Operation (PMOP) has been performed on the materialized view, and no materialized view supports fast refersh after container table PMOPs.

What should we do to fix it:

Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.