Oracle Solution for Error ora-12047

ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string"

What triggered the Error:

PCT refresh is either not enabled on this materialized view or not possible after set of the base table changes since last refresh.

What should we do to fix it:

Use just REFRESH FORCE, which will reinstantiate the entire table and try to pick the best refresh method on the materialized view Do explain_mview to look at the cause why PCT refresh is not possible on this materialized view