步骤:
1、配置tns
2、创建db_link
参考语句:
CREATE [PUBLIC] DATABASE LINK dblink
[CONNECT TO user IDENTIFIED BY password]
[USING 'connect_string']
3、执行insert into a@.. select .. from a where ...;
1、配置tns
2、创建db_link
参考语句:
CREATE [PUBLIC] DATABASE LINK dblink
[CONNECT TO user IDENTIFIED BY password]
[USING 'connect_string']
3、执行insert into a@.. select .. from a where ...;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货