Database DataWarehousing (MOSC)

MOSC Banner

DBMS_SNAPSHOT.REFRESH vs dbms_mview.refresh

edited Apr 16, 2013 1:09AM in Database DataWarehousing (MOSC) 10 commentsAnswered
Hi Guys,

We have a very odd bug here that I can't explain. One of our materialized views is setup for fast refresh.

The source table on an Oracle 11, and the Mview is on Oracle 10.

If we refresh using dbms_mview.refresh, the new records are not found in the mview. However, they are found if we use dbms_snapshot.refresh.

Also, we have other MVs that are not fast refresh, and have been refreshing well.

These are the two statements:

execute dbms_mview.refresh('mv_view'); --Does not work

vs

BEGIN DBMS_SNAPSHOT.REFRESH( '"schema"."MV_View"','C'

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