Materialized Views - Fast Refresh Capability

You can also use the EXPLAIN_MVIEW procedure in the DBMS_MVIEW package to determine the following information about an existing materialized view :

• The capabilities of a materialized view
• Whether each capability is possible
• If a capability is not possible, why it is not possible.

This information can be stored in a varray or in the MV_CAPABILITIES_TABLE. 

 If you want to store the information in the table, then, before you run the EXPLAIN_MVIEW procedure, you must build this table by running the utlxmv.sql script in the Oracle_home/rdbms/admin directory.

Example:

exec dbms_mview.explain_mview('WAREHOUSE.MV_LABORDERS');

Check the errors using - 

select * from mv_capabilities_table
where mvname = 'MV_LABORDERS'
AND CAPABILITY_NAME LIKE '%FAST%'
;