刷新组的维护

来源：互联网发布：dnf烤机数据编辑：程序博客网时间：2024/04/30 05:40

查看刷新组相关信息

--查看刷新组信息。SQL> select rowner,rname,job,next_date,interval from dba_refresh;ROWNER               RNAME                 JOB NEXT_DATE            INTERVAL-------------------- -------------------- ---- -------------------- --------------------MVADMIN              REP_REFRESH             3 17-1月 -12           SYSDATE + 1/24--查看刷新组子信息，包含具体的物化视图，以下 TEST_REP 就是我们创建的MV 。SQL> select owner,name,rowner,rname,job from dba_refresh_children;OWNER                NAME                 ROWNER               RNAME                 JOB-------------------- -------------------- -------------------- -------------------- ----TEST                 TEST_REP             MVADMIN              REP_REFRESH             3--根据job号，可以查看该job的详细内容。以下可知，oracle调用dbms_refresh.refresh对整个刷新--组（REP_REFRESH）进行刷新。SQL> col priv_user for a20SQL> col schema_user for a20SQL> col interval for a20SQL> col what for a20SQL> select job,priv_user,schema_user,interval,what from dba_jobs where job=3; JOB PRIV_USER            SCHEMA_USER          INTERVAL             WHAT---- -------------------- -------------------- -------------------- --------------------   3 MVADMIN              MVADMIN              SYSDATE + 1/24       dbms_refresh.refresh                                                                    ('"MVADMIN"."REP_REF                                                                    RESH"');

与刷新组相关的操作

--新建一个刷新组begin DBMS_REFRESH.MAKE ( name => 'mvadmin.rep_refresh', list => '', next_date => SYSDATE, interval => 'SYSDATE + 1/24', implicit_destroy => FALSE, rollback_seg => '', push_deferred_rpc => TRUE, refresh_after_errors => FALSE); end;/ --添加MV到一个刷新组begin DBMS_REFRESH.ADD(    name => 'rep_refresh',    list => 'test.testmv'    );end;/--更改刷新组的刷新间隔begin DBMS_REFRESH.CHANGE(    name => 'rep_refresh',    next_date => sysdate,    interval => sysdate+(1/(24*60))    );end;/--手动刷新一个刷新组SQL> exec DBMS_REFRESH.REFRESH('rep_refresh');--从刷新组中移除一个物化视图beginDBMS_REFRESH.SUBTRACT (   name => 'mvadmin.rep_refresh',   list => 'test.testmv'   );end;/--移除所有的物化视图并删除刷新组exec DBMS_REFRESH.DESTROY('rep_refresh');

参考：
http://docs.oracle.com/cd/B19306_01/server.102/b14227/rarrefreshpac.htm#REPMA018