Oracle 建立DBlink同步数据

为什么80%的码农都做不了架构师？>>>   

--创建私有dblink
create database link loadstore
connect to xxxx_user identified by password_xxxx
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )';

xxxx_user  源数据库用户名

password_xxxx 源数据库密码
  --查看复制权限
  select * from v$option where PARAMETER='Advanced replication';
  --清空表
  truncate table xxxxx;
  --同步表数据
  insert into xxxxselect * from uatxdgl.xxxx@loadstore;

--删除DBlink

drop database link loadstore

转载于:https://my.oschina.net/TTSK/blog/744366