Database DataWarehousing (MOSC)

MOSC Banner

11gR2 : materialized view logs : FAST

edited Oct 25, 2013 8:43AM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓
Hi ,

I would like to change refresh mode of a materialized view from COMPLETE to FAST.

Should I create a VM Log for EACH MASTER TABLE of this view (ie each table used in the create materialized view script ) or only for  tables that can be modified ?

Best regards.

GD

CREATE MATERIALIZED VIEW MV1
REFRESH FORCE ON DEMAND
AS
SELECT col1, col2 , ... from T
inner join T1 ON ...
inner join T2 ON ...
...
group by ...        
UNION       
SELECT col1, col2 , ... from F
inner join F1 ON ...
inner join F2 ON ...
...
group by ...
UNION  
SELECT col1, col2 , ... from M
inner join M1 ON ...

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