Purpose
The ALL_DB_LINKS view displays all DBLinks accessible to the current user.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The name of the user who created the DBLink. |
| DB_LINK | VARCHAR2(128) | NO | The name of the DBLink. |
| USERNAME | VARCHAR2(128) | NO | The username used to connect to the remote database by using the DBLink. |
| CREDENTIAL_NAME | VARCHAR2(128) | NO | The name of the credentials used to connect to the remote database. This column is used only for compatibility. |
| CREDENTIAL_OWNER | VARCHAR2(128) | NO | The owner of the credentials used to connect to the remote database. This column is used only for compatibility. |
| HOST | VARCHAR2(2000) | NO | The IP address of the remote database connected to by using the DBLink. |
| CREATED | DATE | NO | The time when the DBLink was created. |
| HIDDEN | VARCHAR2(3) | NO | An internal column, which is used only for compatibility. |
| SHARD_INTERNAL | VARCHAR2(3) | NO | Indicates whether the DBLink can be shared by sessions. This parameter is used to reduce the number of DBLinks between the local and remote databases. It is used only for compatibility. |
| VALID | VARCHAR2(3) | NO | Indicates whether the DBLink is available. This column is used only for compatibility, and the default value is YES. |
| INTRA_CDB | VARCHAR2(3) | NO | An internal column, which is used only for compatibility. |
| TENANT_NAME | VARCHAR2(128) | NO | The tenant name used to connect to the remote database by using the DBLink. |
| REVERSE_TENANT_NAME | VARCHAR2(128) | YES | The tenant name used to connect to the local database from the remote database by using the DBLink. |
| CLUSTER_NAME | VARCHAR2(128) | YES | The cluster name used to connect to the remote database by using the DBLink. |
| REVERSE_CLUSTER_NAME | VARCHAR2(128) | YES | The cluster name used to connect to the local database from the remote database by using the DBLink. |
| REVERSE_HOST | VARCHAR2(46) | YES | The IP address used to connect to the local database from the remote database by using the DBLink. |
| REVERSE_PORT | NUMBER(38) | YES | The port number used to connect to the local database from the remote database by using the DBLink. |
| REVERSE_USERNAME | VARCHAR2(128) | YES | The username used to connect to the local database from the remote database by using the DBLink. |