Oracle Error Message
ORA-12004: REFRESH FAST cannot be used for materialized view “string”.”string”
Reason for the Error
The materialized view log does not exist or cannot be used. PCT refresh is also not enabled on the materialized view
Solution
Use just REFRESH, which will reinstantiate the entire table. If a materialized view log exists and the form of the materialized view allows the use of a materialized view log or PCT refresh is possible after a given set of changes, REFRESH FAST will be available starting the next time the materialized view is refreshed.
