SQL> select owner,mview_name,LAST_REFRESH_DATE,STALENESS,MASTER_LINK,REFRESH_MODE,REFRESH_METHOD from all_mviews;
OWNER MVIEW_NAME LAST_REFRESH_DATE STALENESS MASTER_LIN REFRES REFRESH_
---------- ---------- ------------------- ------------------- ---------- ------ --------
TESTER T1MV 2012-09-02 20:46:04 UNDEFINED @NEWDB.MDU DEMAND FAST
TESTER T2MV 2012-09-02 20:44:26 UNDEFINED @NEWDB.MDU DEMAND FORCE
SQL> exec dbms_refresh.refresh('mvadmin.rep_refresh');
PL/SQL procedure successfully completed.
SQL> select owner,mview_name,LAST_REFRESH_DATE,STALENESS,MASTER_LINK,REFRESH_MODE,REFRESH_METHOD from all_mviews;
OWNER MVIEW_NAME LAST_REFRESH_DATE STALENESS MASTER_L