Hi all,

Complete refresh of materialized view works fine, but non-complete doesn't.

Code:
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.
I checked quantity of rows in source table and in destination materialized view.
It was not equal before complete refresh and it became equal after complete refresh.

I don't see this error on other materialized views.

What does it mean and how to solve?
Please tell me what additional information should I provide in order for you to help me.
Thanks ahead.


P.S.: Cross-posted from oracle discussion board, can't really find solution yet.
https://community.oracle.com/thread/...nbox&ru=719145

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production