Note
This view is available starting with V4.4.0.
Overview
ALL_LOCATIONS is used to view the information about the external location objects of the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | Owner |
| LOCATION_NAME | VARCHAR2(128) | YES | Name |
| LOCATION_URL | VARCHAR2(4000) | YES | Path |
| ORIGIN_CON_ID | NUMBER(38) | NO | Tenant ID |
| ACCESS_INFO | VARCHAR2(8000) | YES | Access Information |
| --------------- | ---------------- | ------ | ------ |
Sample query
Query the External Location object information of the current tenant.
obclient [SYS]> SELECT * FROM SYS.ALL_LOCATIONS ;