--在A上创建dblink,连接到B CREATE PUBLIC DATABASE LINK ora1 CONNECT TO scott identified by dba123 USING ' (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.208)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora1) ) ) ';
--在B的customer表上建产物化视图日志 CREATE MATERIALIZED VIEW LOG ON customer;
--在A上创建物化视图 CREATE MATERIALIZED VIEW mv_test REFRESH FAST --START WITH SYSDATE NEXT SYSDATE + 1/4096 /*后面的是定期更新,我这里注释掉了。也可以用dbms_mview.fresh来刷新*/ ON DEMAND AS SELECT * FROM customer@ora1;
CREATE PUBLIC DATABASE LINK ora1
CONNECT TO scott identified by dba123
USING '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.208)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora1)
)
)
';
--在B的customer表上建产物化视图日志
CREATE MATERIALIZED VIEW LOG ON customer;
--在A上创建物化视图
CREATE MATERIALIZED VIEW mv_test
REFRESH FAST --START WITH SYSDATE NEXT SYSDATE + 1/4096 /*后面的是定期更新,我这里注释掉了。也可以用dbms_mview.fresh来刷新*/
ON DEMAND
AS
SELECT *
FROM customer@ora1;