Unanswered: complete refresh of materialized view works fine, but non-complete doesn't
Complete refresh of materialized view works fine, but non-complete doesn't.
PL/SQL procedure successfully completed.
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.
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
PL/SQL Release 22.214.171.124.0 - Production
CORE 126.96.36.199.0 Production
TNS for Linux: Version 188.8.131.52.0 - Production
NLSRTL Version 184.108.40.206.0 - Production