外部库连接-SYS_DBLINKS
📄字数 834
👁️阅读量 加载中...
功能描述
SYS_DBLINKS系统表用于管理数据库建立的外部库链接。
字段说明
| 序号 | 字段名 | 类型 | 说明 | V11 | V12 |
|---|---|---|---|---|---|
| 0 | DB_ID | INTEGER | 库ID | √ | √ |
| 1 | DBLK_ID | INTEGER | ID | √ | √ |
| 2 | DB_TYPE | INTEGER | 类型 | √ | √ |
| 3 | DBLK_NAME | VARCHAR | 连接名 | √ | √ |
| 4 | IP | VARCHAR | 目标IP（或URL） | √ | √ |
| 5 | PORT | INTEGER | 端口号 | √ | √ |
| 6 | RDB_NAME | VARCHAR | 远程库名 | √ | √ |
| 7 | USER_NAME | VARCHAR | 连接用户(v11为USER) | √ | √ |
| 8 | PASSWORD | VARCHAR | 连接口令 | √ | √ |
| 9 | CONNECT_STR | VARCHAR256 | 连接字符串（通常未用） | √ | √ |
| 10 | VALID | BOOLEAN | 是否有效 | √ | √ |
| 11 | IS_PUBLIC | BOOLEAN | 是否全局，公有时：owner_id无效；私有时：owner_id有效 | x | √ |
| 12 | OWNER_ID | INTEGER | 属主 | x | √ |
DB_TYPE
| DB_TYPE | 类型 |
|---|---|
| 0 | UNKNOW |
| 1 | XUGU |
| 2 | OXUGU |
| 3 | ORACLE |
| 4 | MSSQL |
| 5 | MYSQL |
| 6 | DB2 |
| 7 | POSTGRESQL |
| 8 | SQLITE |
| 9 | MARIADB |
应用举例
- 查询数据库建立的外部库连接
sql
SQL> CREATE DATABASE LINK link_info CONNECT TO 'SYSTEM@192.168.2.225:5139' USER 'SYSDBA' IDENTIFIED BY 'SYSDBA';
SQL> SELECT * FROM SYS_DBLINKS WHERE dblk_name='LINK_INFO';
+----------------+------------------+------------------+-------------------------+------------------+---------------+------------------------+-------------------------+---------------------------+----------------+--------------------+-------------------+
| DB_ID(INTEGER) | DBLK_ID(INTEGER) | DB_TYPE(INTEGER) | DBLK_NAME(VARCHAR(128)) | IP(VARCHAR(128)) | PORT(INTEGER) | RDB_NAME(VARCHAR(128)) | USER_NAME(VARCHAR(128)) | CONNECT_STR(VARCHAR(256)) | VALID(BOOLEAN) | IS_PUBLIC(BOOLEAN) | OWNER_ID(INTEGER) |
+----------------+------------------+------------------+-------------------------+------------------+---------------+------------------------+-------------------------+---------------------------+----------------+--------------------+-------------------+
| 1 | 1048595 | 1 | LINK_INFO | 192.168.2.225 | 5139 | SYSTEM | SYSDBA | <NULL> | <NULL> | F | 1 |
+----------------+------------------+------------------+-------------------------+------------------+---------------+------------------------+-------------------------+---------------------------+----------------+--------------------+-------------------+