批量刷新远程物化视图的方法（备用）

来源：互联网发布：一对一色情直播软件编辑：程序博客网时间：2024/06/15 11:40

一、创建远程数据库连接

create database link MDM  connect to MDM  identified by mdm  using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = 172.17.11.1)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SID= MDM)))';

二、创建两个物化视图：

CREATE MATERIALIZED VIEW DEPARTMENTTABLESPACE DAT_ICNFUSING INDEXTABLESPACE IDX_ICNFREFRESH FORCE ON DEMANDASSELECT * FROM MDM.DEPARTMENT@MDM WHERE TREELEVEL = 1 AND STATUS = '0';CREATE MATERIALIZED VIEW EMPLOYEETABLESPACE DAT_ICNFUSING INDEXTABLESPACE IDX_ICNFREFRESH FORCE ON DEMANDASSELECT * FROM MDM.EMPLOYEE@MDM WHERE  STATUS = '0';

三、创建刷新组

execute DBMS_REFRESH.MAKE(NAME=>'MVTAG', LIST=>'DEPARTMENT,EMPLOYEE', NEXT_DATE=>SYSDATE, INTERVAL=>'/*24:HR*/ SYSDATE + 5/(60*24)');commit;

四、删除刷新组

--execute dbms_refresh.destroy('MVTAG');--commit;

邀月注：本文版权由邀月和CSDN共同所有，转载请注明出处。
助人等于自助! 3w@live.cn