刷新組維護

新建刷新組的方法

BEGIN
  DBMS_REFRESH.DESTROY(name => 'MCD.NEW_GB_REF');
Commit;
END;
/

DECLARE
  SnapArray SYS.DBMS_UTILITY.UNCL_ARRAY;
BEGIN
  SnapArray(1) := 'MCD.ATTACHMENTS';
  SnapArray(2) := 'MCD.PART_COLLECTING';
  SnapArray(3) := 'MCD.QUANTITATIVE_SUBSTANCE';
  SnapArray(4) := 'MCD.PART';
  SnapArray(5) := 'MCD.SUBSTANCE_CATEGORY';
  SnapArray(6) := 'MCD.REVIEW_RESULT';
  SnapArray(7) := 'MCD.BASE_SUBSTANCE';
  SnapArray(8) := 'MCD.MATERIAL';
  SnapArray(9) := 'MCD.ATTACHMENT_REF';
  SnapArray(10) := 'MCD.SUBSTANCE_CATEGORY_SETTING';
  SnapArray(11) := NULL;
  SYS.DBMS_REFRESH.MAKE (
    name => 'MCD.NEW_GB_REF'
    ,tab  => SnapArray
    ,next_date => TO_DATE('08/30/2010 10:31:28', 'MM/DD/YYYY HH24:MI:SS')
    ,interval  => '/*8:Mins*/ sysdate + 8/(60*24)'
    ,implicit_destroy => FALSE
    ,lax => TRUE
    ,job => 0
    ,rollback_seg => NULL
    ,push_deferred_rpc => FALSE
    ,refresh_after_errors => TRUE
    ,purge_option => 0
    ,parallelism => 0
    ,heap_size => 0
  );
Commit;
END;
/


將新MV  ROWIDREADONLY,加入到一個刷新組PKREADONLY中

 BEGIN
   DBMS_REFRESH.ADD(
     name => 'PKREADONLY',
     list => 'ROWIDREADONLY',
     lax => TRUE);
END;
/

COMMIT;


將一個MV ROWIDREADONLY從刷新組PKREADONLY中刪除掉

 BEGIN
   DBMS_REFRESH.SUBTRACT(
     name => 'PKREADONLY',
     list => 'ROWIDREADONLY',
     lax => TRUE);
END;
/

COMMIT;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16754036/viewspace-681171/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16754036/viewspace-681171/