oracle通过dblink跨库迁移数据

创建连接：

create database link TNAME
  connect to tadmin identified by "tadmin"
  using '(DESCRIPTION=
     (ADDRESS=(PROTOCOL=tcp)(HOST=10.66.22.33)(PORT=1866))
     (CONNECT_DATA=(SERVICE_NAME=sname))
  )';

复制数据：

 insert into table1
    (id, loginname, article)
  select * from table2@TNAME;
  
commit;

删除链接：

DROP DATABASE LINK TNAME;