前提条件:源端表名c##hbhe.T1,在目标端创建DBLINK名为NODE02DBLINK/hbhe0316/article/5048/hbhe0316/article/5048
1.在源端创建物化视图日志/hbhe0316/article/5048
/hbhe0316/article/5048
SQL> CREATE MATERIALIZED VIEW LOG ON C##HBHE.T1 2 WITH PRIMARY KEY 3 INCLUDING NEW VALUES;Materialized view log created.
2.在目标端授权C##HBHE用户/hbhe0316/article/5048
/hbhe0316/article/5048 /hbhe0316/article/5048 /hbhe0316/article/5048
grant create table to c##hbhe;grant unlimited tablespace to c##hbhe;GRANT CREATE MATERIALIZED VIEW TO c##HBHE;GRANT ON COMMIT REFRESH to C##hbhe;GRANT GLOBAL QUERY REWRITE TO c##hbhe;grant global query rewrite to c##hbhe;grant advisor to c##hbhe;grant create any materialized view to c##hbhe;grant create any view to c##hbhe;grant select any table to c##hbhe;grant select any dictionary to c##hbhe;
3.在目标端创建物化视图/hbhe0316/article/5048/hbhe0316/article/5048
SQL> CREATE MATERIALIZED VIEW HBHE_TEST1 --创建物化视图 2 BUILD IMMEDIATE --在视图编写好后创建 3 REFRESH FAST WITH PRIMARY KEY --根据主表主键增量刷新(FAST,增量) 4 ON DEMAND -- 在用户需要时,由用户刷新 5 ENABLE QUERY REWRITE --可读写 6 AS 7 SELECT * FROM c##hbhe.T1@NODE02DBLINK;Materialized view created.
版权声明:本文为博主原创文章,未经博主允许。
Linux,oracle