Oracle Solution for Error ora-32314

ORA-32314: REFRESH FAST of "string

"."string

" unsupported after deletes/updates

What triggered the Error:

One or more deletes or updates has been performed on one or more of the detail tables referenced by the specified materialized view. This materialized view does not support fast refresh after deletes or updates.

What should we do to fix it:

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