My Oracle Support Banner

Ora-942 Error Refreshing Materialized View After Upgrade to 19C (Doc ID 2887360.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s),

Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead,

is purely coincidental and not intended in any manner.

 

MV1 is selecting from other mviews.

The process in place is to periodically drop and recreate the dependent mviews.

This process worked fine in 12C. But in 19C, it also requires to drop the main mview mv1 after recreating the dependent mviews.

BEGIN dbms_refresh.refresh(<<<>>); END;
Error report -
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2432
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 88
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 253
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2413
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2976
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3322
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 44
ORA-06512: at "SYS.DBMS_IREFRESH", line 1177
ORA-06512: at "SYS.DBMS_REFRESH", line 263
ORA-06512: at line 1
00942. 00000 - "table or view does not exist"
*Cause:

Changes

 Upgrade to 19C

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.