This content has been marked as final. Show 6 replies
For the specific 10g case of
LIST => 'XYZ_DETAIL'
,METHOD => 'C'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE);
and using PARALLELISM of 8 for a specific refresh
can you tell us what are the differences in Materialized Views , say between
10gR1 and 10gR2 if you can't tell us the differences between 8i and 10g ?
Message was edited by:
Hemant K Chitale
This is to refresh the MView itself.
The Snapshot Log on the base (source) table is automatically maintained -- any
DML on the source table immediately updates the Snapshot Log.
The process of refreshing the MV requires reading of the Snapshot Log to identify
changes in the source table. Thus, we refresh the MV, not the Log.