Database DataWarehousing (MOSC)

MOSC Banner

Why is my refresh using a complete instead of a fast?

edited Jul 22, 2012 6:32PM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓
I'm using version 11gR2

I logged on to DB1 on Server1 as user1 and created a materialized view log on table1

I then logged on to DB2 on server2 as user2 and created a materialized view table1_mv on table1 using REFRESH FORCE ON DEMAND. The query is a straight select * from table1@dblink_to_db1

Noone is currently using the table so there have been no inserts/updates/deletes.

I then ran:

begin

   dbms_mview.refresh('user2.table1_mv');

end;

/

As I understand it, a FORCE refresh should be run. It would attempt "a FAST refresh is one is possible or a Complete refresh if a fast is not"

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