Skip to Main Content

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

2792584Mar 2 2015 — edited Mar 10 2015

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Apr 7 2015
Added on Mar 2 2015
19 comments
5,828 views