Database Administration (MOSC)

MOSC Banner

Ensure all materialized view refreshes are complete prior to upgrade

edited Feb 23, 2013 1:17AM in Database Administration (MOSC) 5 commentsAnswered
I got this messge in the log of utlu112i.sql script

WARNING: --> There are materialized view refreshes in progress.
.... Ensure all materialized view refreshes are complete prior to upgrade.

I ran the select statemen

SQL> SELECT DISTINCT(TRUNC(last_refresh))
FROM dba_snapshot_refresh_times;
  2
(TRUNC(LAST_REFRESH)
--------------------
10-JUN-2005 00:00:00
15-JAN-2013 00:00:00
05-FEB-2013 00:00:00

Here is the result. Should I do something on these 3 mviews?

Thanks

Tracy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center