This discussion is archived
6 Replies Latest reply: May 24, 2008 9:42 AM by 26741 RSS

10g Refresh Snapshot log question

549855 Newbie
Currently Being Moderated
Hi,
I need to run complete refresh on a materialized view log.

BEGIN
DBMS_SNAPSHOT.REFRESH(
LIST => 'XYZ_DETAIL'
,METHOD => 'C'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE);
END;

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.
Thanks.