dbms_mview.explain_mview analyzes a given materialized view in terms of its refresh and rewrite capabilities, store result in mv_capabilities_table or msg_array. mv_capabilities_table can be created by running the SQL script $ORACLE_HOME/rdbms/admin/utlxmv.sql.