oracle pl/sql 建立db_link

Create  DATABASE  LINK 数据库链接名 CONNECT  TO  用户名   IDENTIFIED  BY  密码   USING  ‘本地配置的数据的实例名 ’;


create database link DBL_TYBSDB
  connect to tydbmgr identified by tydbmgr
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.11.11)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TYBSDB)
    )
  )';
  
  drop database link DBL_TYBSDB;