SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_mview.refresh giving "ORA-00942: table or view does not exist"

atom6008Sep 3 2013 — edited Sep 4 2013

Hi All,

I am trying to refresh the MV using dbms_mview package but its giving me the following error,

"ORA-00942: table or view does not exist"

I have a MV named TESTMV in my environment. I am executing the following command,

begin

dbms_mview.refresh('TESTMV,'C');

end;

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2545

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2751

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2720

ORA-06512: at line 3

Any suggestions would be highly appreciated.

Cheers,

ATOM

This post has been answered by TSharma-0racle on Sep 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2013

Added on Sep 3 2013

27 comments

32,593 views