创建Oracle的database link

SELECT * FROM GLOBAL_NAME;

 

create database link mylink1 connect to username identified by password

  using '(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.111.222.333)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = theServer)

    )

  )';

 

//删除link

drop database link mylink1;

 

select 1 from dual@mylink1;