创建数据库连接
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
to gaoxiulan(ll) : 我替楼主问一下,如果用imp导入数据,那A台上的数据能增量导入吗???
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
就可以满足了
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
连接字符串: 服务名
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
连接字符串就是网络服务名:例如ora92.
create public database link dlname connect to user identified by pw
using '连接字符串'insert into tbname_a select * from tbname_b@dlname
create public database link dlname connect to user identified by pw
using '连接字符串' //事先指定insert into tbname_a select * from tbname_b@dlname
如果偶尔一次的保持,不如就用exp 和imp,也可用脚本做成自动的导出和导入