Purpose
The oceanbase.DBA_DB_LINKS view displays all DBLinks created in the current tenant.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | varchar(128) | NO | The name of the user who created the DBLink. |
| DB_LINK | varchar(128) | NO | The name of the DBLink. |
| USERNAME | varchar(128) | NO | The username used to connect to the remote database by using the DBLink. |
| CREDENTIAL_NAME | varchar(128) | NO | The name of the credentials used to connect to the remote database. This column is used only for compatibility. |
| CREDENTIAL_OWNER | varchar(128) | NO | The owner of the credentials used to connect to the remote database. This column is used only for compatibility. |
| HOST | text | YES | The IP address of the remote database connected to by using the DBLink. |
| CREATED | datetime | NO | The time when the DBLink was created. |
| HIDDEN | varchar(3) | NO | An internal column, which is used only for compatibility. |
| SHARD_INTERNAL | varchar(3) | NO | Indicates whether the DBLink supports shared connections so as to decrease the number of connections between the local and remote databases. This column is used only for compatibility. |
| VALID | varchar(3) | NO | Indicates whether the DBLink is available. This column is used only for compatibility, and the default value is YES. |
| INTRA_CDB | varchar(3) | NO | An internal column, which is used only for compatibility. |
| TENANT_NAME | varchar(128) | NO | The tenant name used to connect to the remote database by using the DBLink. |
| DATABASE_NAME | varchar(128) | YES | The name of the remote database connected to by using the DBLink. |
| REVERSE_TENANT_NAME | varchar(128) | YES | The tenant name used to connect to the local database from the remote database by using the DBLink. |
| CLUSTER_NAME | varchar(128) | YES | The cluster name used to connect to the remote database by using the DBLink. |
| REVERSE_CLUSTER_NAME | varchar(128) | YES | The cluster name used to connect to the local database from the remote database by using the DBLink. |
| REVERSE_HOST | text | YES | The IP address used to connect to the local database from the remote database by using the DBLink. |
| REVERSE_PORT | bigint(20) | 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. |