读书人

oracle 创造DBLINK

发布时间: 2013-03-16 11:51:46 作者: rapoo

oracle 创—BLINK

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 * fromfin_contractor_info@to_113jmis

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


读书人网 >其他数据库

热点推荐