Oracle Solution for Error ora-32313

ORA-32313: REFRESH FAST of "string

"."string

" unsupported after PMOPs

What triggered the Error:

A Partition Maintenance Operation (PMOP) has been performed on a detail table, and the specified materialized view does not support fast refersh after 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.