Database DataWarehousing (MOSC)

MOSC Banner

dba_snapshots / dba_mviews

edited Jan 14, 2010 12:47AM in Database DataWarehousing (MOSC) 3 commentsAnswered
In my Oracle 9.2.0.8.0 database I have a dba_job entry that fires off a dbms_refresh.refresh which populates a materialized view. Now as I have this materialized view in both dba_snapshots and dba_mviews will it try and refresh it twice? Should I only have dba_mviews?

 

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