Materialized View Manual Refresh

 col OWNER for a20

col MVIEW_NAME for a30

col LAST_REFRESH_DATE for a40

select OWNER, MVIEW_NAME, LAST_REFRESH_DATE from dba_mviews where owner='POND' and MVIEW_NAME='RC_MU_11';

execute DBMS_MVIEW.REFRESH( LIST => 'POND.RC_MU_11', METHOD => 'F');

col OWNER for a20

col MVIEW_NAME for a30

col LAST_REFRESH_DATE for a40

select OWNER, MVIEW_NAME, LAST_REFRESH_DATE from dba_mviews where owner='POND' and MVIEW_NAME='RC_MU_11';