Oracle Database Error Code ORA-12004 Description :
REFRESH FAST cannot be used for materialized view “string”.”string”
Error Cause:
The materialized view log does not exist or cannot be used. PCT refresh is also not enabled on the materialized view
How to Solve :
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.
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below