1.创建DBLINK -- Drop existing database link drop public database link LQPVPUB; -- Create database link CONNECT using "LQPVPUB" 2.创建物化视图日志(远程主机操作) CREATE MATERIALIZED VIEW LOG ON dm_basicmodel WITH PRIMARY KEY INCLUDING NEW VALUES; 3.创建物化视图 CREATE
create materialized view MV_XXXXrefresh fast on commitwith rowidenable query rewriteasselect * from SYS_USER where (USER_STATUS=0 AND USER_HR=1); oracle 有个机制,一旦条件与物化视图里的一样,那么会自动使用物化视图表
使用过程 ----删除 TRUNCATE TABLE mlog$_xxx_lxz_tmp;DROP MATERIALIZED VIEW LOG ON xxx_lxz_tmp; drop materialized view mv_xxx_lxz_tmp ----原表创建增量刷新日志 CREATE MATERIALIZED VIEW LOG ON xxx_lxz_tmp WITH PRIMARY KEY INCLUDING NEW VALUES; ----创建物化视图 CREATE MATERIA