oracle dblink 创建使用 垮库转移数据
标签：
oracle dblink 创建使用 垮库转移数据
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;