Monday, 19 May 2014

ORA-32313 REFRESH FAST of "string"."string" unsupported after PMOPs

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