Oracle｜创建 DB Link

-- Create database link 
create public database link UTMS_TEST_81
  connect to UTMS identified by Vi_ts#81
  using '(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.136.207)(PORT = 17632)))(CONNECT_DATA = (SERVICE_NAME = UTMS) ) )';

-- Drop existing database link 
drop public database link UTMS_TEST_81;

--查看A服务器实例名称，主机名，版本号
SELECT instance_name,host_name,version FROM v$instance;

--查看dblink服务器实例名称，主机名，版本号
SELECT instance_name,host_name,version FROM v$instance@UTMS_TEST_81;

--A服务器用户密码
select pn_password from person where id = 'w06549';

--dblink服务器用户密码
select pn_password from person@UTMS_TEST_81 where id = 'w06549';

--执行更新语句，将dblink用户密码更新到A服务器用户密码
update person set pn_password = (select pn_password from person@UTMS_TEST_81 where id = 'w06549') where id = 'w06549';

--再次查看A服务器用户密码
select pn_password from person where id = 'w06549';