My Oracle Support Banner

Sporadic Ora-942 On Fast Mv Refresh (Doc ID 1441678.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Goal

Getting error ora-942 on mview refresh intermittently.Even though the user has all the privileges needed to refresh.

ORA-12048: error encountered while refreshing materialized view "O_PRODUCT"."WEBSITE_PSS_MV" 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 2


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.