My Oracle Support Banner

11g 업그레이드 동안 mview refresh 경고 (Doc ID 1966002.1)

Last updated on AUGUST 04, 2018

적용 대상:

Oracle Database - Enterprise Edition - 버전 10.2.0.4 과(와) 그 후속
이 문서의 내용은 모든 플랫폼에 적용됩니다.
***Checked for relevance on 27-Aug-2013***

목적


11g 업그레이드 동안 DBUA 를 수행시 다음의 경고를 얻습니다.


오라클 문서에서 다음과 같이 언급하고 있습니다. 그러나 그 쿼리는 잘못되었습니다:
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!


이 문서에서
목적
해결책
참고

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