Description:-
ORA-12012: error on auto execute of job "SCHEMA_NAME"."JOB_NAME".
ORA-12048: error encountered while refreshing materialized view "SCHEMA_NAME"."MV_NAME".
ORA-32313: REFRESH FAST of "SCHEMA_NAME"."MV_NAME" unsupported after PMOPs.
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566.
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779.
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2748. ORA-06512: at line 7.
Cause:-
Oh-oh. What’s gone on here then? Well it turns out that you can’t refresh a fast-refresh materialized view when you perform a partition maintenance operation (PMOP) on the underlying table, which if you think about it is obvious because the associated materialized view logs won’t contain details of what data has changed.
A Partition Maintenance Operation (PMOP) has been performed on a detail table, and the specified materialized view does not support fast refresh after PMOPs.
For Complete Refresh :-
dbms_mview.refresh('Schema_name.MV_Name','C');
Then try Fast Refresh as like below:-
dbms_mview.refresh('Schema_name.MV_Name','ff');
No comments:
Post a Comment