Hi all,
Complete refresh of materialized view works fine, but non-complete doesn't.
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.
What does it mean and how to solve?
Thanks ahead.