1. 在A库中创建dblink连接到B库
create database link dblink_name
connect to user identified by pwd
using service_name ; --B库的用户名和密码,连接字符串
2. insert into test_a select * from test_a@dblink_name where ...
1. 在A库中创建dblink连接到B库
create database link dblink_name
connect to user identified by pwd
using service_name ; --B库的用户名和密码,连接字符串
2. insert into test_a select * from test_a@dblink_name where ...