如题 两台linux机器 A 机器上有表 ONOFF 在A机器上建立 CREATE MATERIALIZED VIEW LOG ON ONOFF;在B机器上创建DBLINK CREATE PUBLIC DATABASE LINK A2B CONNECT TO USERNAME IDENTIFIED BY PASSWORD USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME=ORCL)
)
)';再在B机器上创建物化视图 create materialized view onoff_mv refresh fast start with sysdate next
sysdate+1/24*60 as select * from ONOFF@A2B;
现在是对这个表中的所有数据同步过来,我想只将ONOFF表中的新增数据同步过来 该如何实现
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME=ORCL)
)
)';再在B机器上创建物化视图 create materialized view onoff_mv refresh fast start with sysdate next
sysdate+1/24*60 as select * from ONOFF@A2B;
现在是对这个表中的所有数据同步过来,我想只将ONOFF表中的新增数据同步过来 该如何实现
看你同步需求,实时还是延时