oracle dblink 创建使用 垮库转移数据
时间：2021-07-01 10:21:17
帮助过：5人阅读
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;
oracle dblink 创建使用 垮库转移数据
标签：
