oracle dblink 创建使用 垮库转移数据

create  database link JTKHJFDB
connect to khjf identified by hello
using ‘(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.196.57.197)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = JTKHJFDB)
    )
  )‘
;
select  party_id,realname from tbl_person ;
select * from  t_customer@JTKHJFDB ;
delete from t_customer@JTKHJFDB  
create synonym remote_seq for PK_SEQ@JTKHJFDB;
insert into t_customer@JTKHJFDB(ID, uuid,name) select remote_seq.nextval, to_char(party_id),realname from tbl_person;
Drop   DATABASE LINK JTKHJFDB;