日期:2014-05-16 浏览次数:20411 次
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
--一个库数据复制到另一个库中。