1、先建立一个database link,将两个库连接起来 create database link mylink connect to user_name identified by password using 'test01' 2、用insert into将test01表a的数据写入test表a insert into a select * from a@mylink
1、先建立一个database link,将两个库连接起来 create database link mylink connect to user_name identified by password using 'test01' 2、用insert into将test01表a的数据写入test表a insert into a select * from a@mylink