MVIEW REFRESH시 에러발생(ORA-32313)

[에러]

    ERROR at line 1:
    ORA-32313: REFRESH FAST of "SWSIS"."TA_E012_MV" unsupported after PMOPs
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 820
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858
    ORA-06512: at "SWSIS.JU_TMP", line 851
    ORA-06512: at line 1


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

Cause: A Partition Maintenance Operation (PMOP) has been performed on a detail table, and the specified materialized view does not support fast refersh after PMOPs.

Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

 

[해결방안]

     MVIEW를 전체 REFRESH해 준다

 

[예제]
       

     DBMS_MVIEW.REFRESH('TA_E012_MV', 'C');