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