1.查询数据库中要同步的表是否有外键,生成让外键失效的SQL并执行
select 'ALTER TABLE XX.'||table_name||' DISABLE CONSTRAINT ' ||CONSTRAINT_NAME||';' from sys.all_constraints c where c.constraint_type = 'R'
AND table_name like 'YY%';
2.truncate本库中要同步表的数据
truncate table XX.TAB;
3.在本库建立对方库的DBLINK
create public database link DBLINK
connect to xx identified by xx_pwd
using 'ip:port/service_name';
4.编辑好插入数据并执行
insert into XX.TAB select * from XX.TAB@DBLINK;
5.参考步骤1让外键生效ENABLE