日期:2014-05-16  浏览次数:20388 次

oracle 创建DBLINK

create public database link to_113jmis connect to gh_jmis identified by gh_jmis using '113jmis';

--to_113jmis dblink 名称,gh_jmis/gh_jmis用户名,113jmis本地dns.

select * from fin_account_payment_split@to_115jmis

 

delete fin_contractor_info@to_115jmis;

 

insert into fin_contractor_info@to_115jmis select * from fin_contractor_info@to_113jmis

--一个库数据复制到另一个库中。