Oracle Database Error Code ORA-12047 Description :
PCT FAST REFRESH cannot be used for materialized view “string”.”string”
Error Cause:
PCT refresh is either not enabled on this materialized view or not possible after set of the base table changes since last refresh.
How to Solve :
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
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below