本文介绍如何使用Oracle SQL创建数据库链接（Database Link），并基于此链接创建快照日志及定时刷新的快照表，实现跨数据库的数据同步。
-- Create database link
create database link DBLINK_HK.US.ORACLE.COM
connect to TK_DOCMANAGER identified by PASSWORD
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.3.245)(PORT = 1521))
)
(CONNECT_DATA =
(sid = kmhk)
)
)';
create snapshot log on tablename with rowid;
create snapshot sn_tablename refresh complete with rowid start with sysdate+5/24*60*60 next sysdate+5/24*60*60
as select * from tablename@dblink_hk;--5s refresh
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
