Oracle创建dblink

删除dblink

drop database link linkname;--要删除的link名称

 创建dblink

create database link name_link
  connect to tname IDENTIFIED BY pwd
  using '(DESCRIPTION =
          (ADDRESS_LIST =
              (ADDRESS =
                 (PROTOCOL = TCP)
                 (HOST = 192.168.0.203)
                 (PORT = 1521)) )
              (CONNECT_DATA =
                  (SERVICE_NAME = orcl)
         ) )';