Oracle教程 2023-02-23

Oracle 视图 ALL_DB_LINKS 官方解释，作用，如何使用详细说明

ALL_DB_LINKS是Oracle中可用于查看拥有者创建的数据库链接的视图。它拥有一些有关链接到两个远程目标字符集、连接类型、最后一次成功连接日期等记录的列。

使用本视图，用户可以便捷地查询和检查他们数据库内的链接，也可以检索两个连接的属性，以便进行比较或产生报告。

使用该视图的基本语句如下：

SELECT * FROM ALL_DB_LINKS;

此外，用户也可以使用WHERE子句使用owner查询该目标中的特定链接，例如：

SELECT * FROM ALL_DB_LINKS WHERE OWNER=’JONES’;

ALL_DB_LINKS describes the database links accessible to the current user.

Related Views

DBA_DB_LINKS describes all database links in the database.
USER_DB_LINKS describes the database links owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the database link
`DB_LINK`	`VARCHAR2(128)`	`NOT NULL`	Name of the database link
`USERNAME`	`VARCHAR2(128)`		Name of the user to be used when connecting to a remote database
`CREDENTIAL_NAME`	`VARCHAR2(128)`		Name of the credential to be used when connecting to a remote database
`CREDENTIAL_OWNER`	`VARCHAR2(128)`		Owner of the credential to be used when connecting to a remote database
`HOST`	`VARCHAR2(2000)`		Oracle Net connect string
`CREATED`	`DATE`	`NOT NULL`	Creation time of the database link
`HIDDEN`	`VARCHAR2(3)`		For internal use only
`SHARD_INTERNAL`	`VARCHAR2(3)`		Indicates whether the database link is used to support operations across sharded databases. Possible values: `YES`: The database link is used and managed for to support sharded databases `NO`: The database link is not used and managed to support sharded databases Users should not alter or delete database links that are used and managed to support sharded databases.
`VALID`	`VARCHAR2(3)`		Indicates whether the database link is valid and usable. Possible values: `YES`: The database link is valid and usable. `NO`: The database link is invalid and unusable.
`INTRA_CDB`	`VARCHAR2(3)`		For internal use only