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 laterInformation 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 |