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

Last updated on NOVEMBER 20, 2016

Applies to:

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

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms