2.113 ALL_DB_LINKS
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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the database link |
|
|
|
Name of the database link |
|
|
|
Name of the user when logging in |
|
|
|
Oracle Net connect string |
|
|
|
Creation time of the database link |
|
|
|
For internal use only |
|
|
|
Indicates whether the database link is used to support operations across sharded databases. Possible values:
Users should not alter or delete database links that are used and managed to support sharded databases. |
|
|
|
Indicates whether the database link is valid and usable. Possible values:
|
|
|
|
For internal use only |
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.
See Also: