dblink

oracle dblink 创建查看删除

   --创建dblink  host：主机名 port  端口  service_name  数据库实例名 （SSID）     CREATE DATABASE LINK link_orcl_test --dblink 连接名称    CONNECT TO orcl_test  IDENTIFIED BY orcl_test -- 数据库登录名和密码     USING '(DESCRIPTION =    (ADDRESS_LIST =    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))      )    (CONNECT_DATA =    (SERVER = DEDICATED)    (SERVICE_NAME = orcl)    )    )';    --查看dblink     select a.*from dba_db_links a WHERE a.DB_LINK = 'LINK_ORCL_TEST';    --删除dblink    DROP  DATABASE LINK LINK_ORCL_TEST;