begin
DBMS_SNAPSHOT.REFRESH('SNAP_AP_PAY_SCHED','C');
end;

PL/SQL procedure successfully completed.
 

begin
DBMS_SNAPSHOT.REFRESH('SNAP_AP_PAY_SCHED');
end;

ORA-00942: table or view does not exist
ORA-02063: preceding line from PLSDW
ORA-02063: preceding 2 lines from PRODFIN.PLSPRO.COM
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2994
ORA-06512: at line 2

Script Terminated on line 1.

select username from sys.dba_db_links where db_link = 'PRODFIN'

USERNAME                    
------------------------------
APPS                        

1 row selected.

select LOG_OWNER, LOG_TABLE from dba_mview_logs@prodfin dml
where master = 'AP_PAYMENT_SCHEDULES_ALL'

LOG_OWNER                      LOG_TABLE                   
------------------------------ ------------------------------
AP                             MLOG$_AP_PAYMENT_SCHEDULES  

1 row selected.


select 1 t from AP.AP_PAYMENT_SCHEDULES_ALL@prodfin where rownum = 1

         T
----------
         1
1 row selected.


select 1 t from AP.MLOG$_AP_PAYMENT_SCHEDULES@prodfin where rownum = 1

         T
----------
         1
1 row selected.