My Oracle Support Banner

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

Last updated on JANUARY 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 27-Aug-2013***


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;


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

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.