学步园

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;