Oracle物化视图，物化视图日志，增量刷新同步远…

 -- Drop existing database link 

 drop public database link LQPVPUB;
 
 -- Create database link 

 CREATE DATABASE LINK LQPVPUB 6 
 CONNECT TO "INTEPDM" identified by "password" 8 
 using "LQPVPUB"

 CREATE MATERIALIZED VIEW LOG ON dm_basicmodel  

 WITH PRIMARY KEY  

 INCLUDING NEW VALUES;

 CREATE MATERIALIZED VIEW mv_model --创建物化视图 
 BUILD IMMEDIATE --在视图编写好后创建
 REFRESH FAST WITH PRIMARY KEY --根据主表主键增量刷新（FAST，增量）
 ON DEMAND -- 在用户需要时，由用户刷新 
 ENABLE QUERY REWRITE --可读写
 AS
 SELECT bm_id,bm_partid,bm_code from dm_basicmodel@LQPVPUB t --查询语句

 DROP MATERIALIZED VIEW LOG ON GG_ZLX_ZHU@TOCPEES;   

 DROP MATERIALIZED VIEW GG_ZLX_ZHU;  

CREATE OR REPLACE PROCDURE P_MVIEW_REFRESH AS  

BEGIN  

    DBMS_MVIEW.REFRESH('GG_ZLX_ZHU,GG_ZLX_FU','ff');  

END P_MVIEW_REFRESH;  

SELECT mview_name, last_refresh_date, fullrefreshtim, increfreshtim

FROM dba_mview_analysis

WHERE owner='JOHN';