oracle 将正式库数据追加到测试库同名表

需要将正式环境的数据追加到测试环境同名表中。
为确保正式环境数据安全（防误操作）
1.先备份正式环境需要操作的表。
2.使用备份的表来操作更新到测试环境
正式环境备份需要操作的表

----正式环境备份一会需要插入操作的表
create table VISIT_SCHEDULE_bak1127 as select * from VISIT_SCHEDULE

 select * from VISIT_SCHEDULE_bak1127 where CREATION_TIME >to_date('2019-11-26 14:51:11','YYYY-MM-DD HH24:MI:SS' )
----正式环境备份一会需要插入操作的表
create table VISIT_DISTRIBUTOR_RECORD_1127 as select * from VISIT_DISTRIBUTOR_RECORD


 select * from VISIT_DISTRIBUTOR_RECORD_1127 where CREATION_TIME >to_date('2019-11-26 14:51:11','YYYY-MM-DD HH24:MI:SS' )

查询database link 对象，有则使用 无则创建
select owner,object_name from dba_objects where object_type='DATABASE LINK';
select * from dba_db_links;

----使用merge into A  using B A为目标表（测试环境）B为正式环境的备份表
----根据ID匹配如果匹配不到就inser into

merge into  VISIT_DISTRIBUTOR_RECORD@dblink a--目标测试环境同名表
using VISIT_DISTRIBUTOR_RECORD_1127 b---源表（正式库）
on (a.id = b.id)
when not matched then
  insert (a.ID, a.REMARK, a.IS_ENABLE, a.DR, a.TS, a.CREATOR, a.CREATION_TIME, a.MODIFIER, a.MODIFIED_TIME, a.CODE, a.PERSON_ID, a.SUBJECT_ID, a.VISIT_DATE, a.DISTRIBUTOR_ID, a.IS_POTENTIAL, a.SIGN_TIME, a.SIGN_ADDRESS, a.HEADDOOR_PHOTOS, a.STATUS, a.ORGANIZATION_ID, a.MARKET_AREA_ID, a.CANCEL_REASON, a.IS_SIGNED, a.FINISH_TIME, a.CUSTOMER_LEVEL, a.CUSTOMER_TYPE, a.CUSTOMER_CHANNEL_TYPE)
  values (b.ID, b.REMARK, b.IS_ENABLE, b.DR, b.TS, b.CREATOR, b.CREATION_TIME, b.MODIFIER, b.MODIFIED_TIME, b.CODE, b.PERSON_ID, b.SUBJECT_ID, b.VISIT_DATE, b.DISTRIBUTOR_ID, b.IS_POTENTIAL, b.SIGN_TIME, b.SIGN_ADDRESS, b.HEADDOOR_PHOTOS, b.STATUS, b.ORGANIZATION_ID, b.MARKET_AREA_ID, b.CANCEL_REASON, b.IS_SIGNED, b.FINISH_TIME, b.CUSTOMER_LEVEL, b.CUSTOMER_TYPE, b.CUSTOMER_CHANNEL_TYPE);
------
以上方便查阅