DBMS_SNAPSHOT.REFRESH vs dbms_mview.refresh
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 workvs
BEGIN DBMS_SNAPSHOT.REFRESH( '"schema"."MV_View"','C'