Oracle DB Link

iteye_18215

于 2010-11-05 12:53:40 发布

阅读量113

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： Oracle SQL

本文链接：https://blog.youkuaiyun.com/iteye_18215/article/details/81959324

数据库专栏收录该内容

12 篇文章

订阅专栏

本文介绍如何使用PL/SQL创建数据库链接，并通过具体示例演示如何利用该链接进行跨数据库操作。示例中详细展示了创建数据库链接、执行跨数据库插入操作及关闭链接的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在Pl/SQL里想从一个数据库里连接到另一个数据库,要靠Database link.例子如下:

DROP DATABASE LINK elinkDB_copy;       
CREATE DATABASE LINK elinkDB_copy       
  CONNECT TO nims IDENTIFIED BY nims       
  USING '(DESCRIPTION =       
    (ADDRESS_LIST =       
      (ADDRESS = (PROTOCOL = TCP)(HOST = dev.elinksoft.com)(PORT = 1521))       
    )       
    (CONNECT_DATA =       
      (SERVICE_NAME = elinkdb)       
    )       
  )';       
INSERT INTO T_DEPARTMENT_DEFINE       
            (DEPARTMENT_CODE, INTERNAL_DEPARTMENT_CODE,       
             DEPARTMENT_CHINESE_NAME, DEPARTMENT_ABBR_NAME, DEPARTMENT_LEVEL,       
             FOUND_DATE, CHINESE_ADDRESS, POSTCODE, TELEPHONE,       
             UPPER_DEPARTMENT_CODE, LINK_MAN_CODE, TELE_AREA_CODE,       
             LEVEL_DEP_CODE, FCD, FCU, LCD, LCU)       
   (SELECT DEPARTMENT_CODE, INTERNAL_DEPARTMENT_CODE, DEPARTMENT_CHINESE_NAME,       
           DEPARTMENT_ABBR_NAME, DEPARTMENT_LEVEL, FOUND_DATE,       
           CHINESE_ADDRESS, POSTCODE, TELEPHONE, UPPER_DEPARTMENT_CODE,       
           LINK_MAN_CODE, TELE_AREA_CODE, LEVEL_DEP_CODE, FCD, FCU, LCD, LCU       
      FROM T_DEPARTMENT_DEFINE@elinkDB_copy);       
commit;       
ALTER SESSION CLOSE DATABASE LINK elinkDB_copy;