6 Replies Latest reply: May 24, 2008 11:42 AM by 26741 RSS

    10g Refresh Snapshot log question

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