During 11g Upgrade, Mview refresh warning
(Doc ID 1442457.1)
Last updated on OCTOBER 16, 2019
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***
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