oracle创建dblink 并应用

-- dba 权限下执行
grant create public database link,create database link to kangxu;

-- Create database link 
create database link DBLINK_Studnet
  connect to kangxu 
  IDENTIFIED BY kangxu
  using '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sid)
    )
  )';

--使用 dblink
select * from tb_student@dblink_studnet ;