My Oracle Support Banner

During 11g Upgrade, Mview refresh warning (Doc ID 1442457.1)

Last updated on OCTOBER 20, 2023

Applies to:

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

Goal


During 11g upgrade, running DBUA getting following warning


The Oracle documentation says the following, however, the query is incorrect:
Oracle® Database Upgrade Guide
11g Release 2 (11.2)
Part Number E23633-04

Verifying That Materialized View Refreshes Have Completed
==================================================
You must wait until all materialized views have completed refreshing before upgrading. You can query the system to determine if there are any materialized view refreshes still in progress.

To determine if there are any materialized view refreshes still in progress

* Run the following query

SQL> SELECT FROM sys.obj$ o, sys.user$ u, sys.sum$ s
WHERE o.type# = 42 AND bitand(s.mflags, 8) = 8;


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


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