I would like to Refresh it with PARALLELISM => 8 , and after the rebuild will finish
i want to set it back to serial (e.g: PARALLELISM => 0).
Is there an ALTER command that i can use ?
Please explain how to do that.
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 ?