ALL_DB_LINKS describes the database links accessible to the current user.
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(30) |
NOT NULL |
Owner of the database link |
DB_LINK |
VARCHAR2(128) |
NOT NULL |
Name of the database link |
USERNAME |
VARCHAR2(30) |
Name of the user when logging in | |
HOST |
VARCHAR2(2000) |
Oracle Net connect string | |
CREATED |
DATE |
NOT NULL |
Creation time of the database link |
See Also: