Note
OceanBase Database introduces this view since V4.1.0.
Feature
DBA_DB_LINKS displays all DBLinks created under the current tenant.
Fields
| Field | 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 credential used to connect to the remote database. This field is used only for compatibility. |
| CREDENTIAL_OWNER | VARCHAR2(128) | NO | The owner of the credential used to connect to the remote database. This field 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 field, 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 field is used only for compatibility, and the default value is YES. |
| INTRA_CDB | VARCHAR2(3) | NO | An internal field, 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. |