达梦2245_达梦数据库DBLINK配置经验分享

登录到达梦数据库，创建dblink 并查询oralce数据库中scott用户下的表信息。

[root@oracleadg2 ~]# /dameng7/dmdbms/bin/disql sysdba/oracle

服务器[LOCALHOST:5236]:处于普通打开状态

使用普通用户登录

登录使用时间: 81.288(毫秒)

disql V7.1.5.117-Build(2016.09.29-73607)ENT

Connected to: DM 7.1.5.117

SQL> create or replace link ceshi connect 'ORACLE' with SCOTT identified by "tiger" using '(DESCRIPTION =

2   (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.40)(PORT = 1521)))

3   (CONNECT_DATA = (SERVICE_NAME = ora11g)))';

操作已执行

已用时间: 61.119(毫秒). 执行号:8.

SQL> select * from emp@ceshi;

行号     EMPNO ENAME  JOB       MGR  HIREDATE                    SAL     COMM    DEPTNO

---------- ----- ------ --------- ---- --------------------------- ------- ------- ------

1          7369  SMITH  CLERK     7902 1980-12-17 00:00:00         800.00  NULL    20

2          7499  ALLEN  SALESMAN  7698 1981-02-20 00:00:00         1600.00 300.00  30

3          7521  WARD   SALESMAN  7698 1981-02-22 00:00:00         1250.00 500.00  30

4          7566  JONES  MANAGER   7839 1981-04-02 00:00:00         2975.00 NULL    20

5          7654  MARTIN SALESMAN  7698 1981-09-28 00:00:00         1250.00 1400.00 30

6          7698  BLAKE  MANAGER   7839 1981-05-01 00:00:00         2850.00 NULL    30

7          7782  CLARK  MANAGER   7839 1981-06-09 00:00:00         2450.00 NULL    10

8          7788  SCOTT  ANALYST   7566 1987-04-19 00:00:00         3000.00 NULL    20

9          7839  KING   PRESIDENT NULL 1981-11-17 00:00:00         5000.00 NULL    10

10         7844  TURNER SALESMAN  7698 1981-09-08 00:00:00         1500.00 0       30

11         7876  ADAMS  CLERK     7788 1987-05-23 00:00:00         1100.00 NULL    20

行号     EMPNO ENAME  JOB     MGR  HIREDATE                    SAL     COMM DEPTNO

---------- ----- ------ ------- ---- --------------------------- ------- ---- ------

12         7900  JAMES  CLERK   7698 1981-12-03 00:00:00         950.00  NULL 30

13         7902  FORD   ANALYST 7566 1981-12-03 00:00:00         3000.00 NULL 20

14         7934  MILLER CLERK   7782 1982-01-23 00:00:00         1300.00 NULL 10

14 rows got

已用时间: 105.881(毫秒). 执行号:9.

测试成功