Note
This view is available starting with V3.2.1.
Purpose
This view displays all directories accessible to the current user.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the directory. |
| DIRECTORY_NAME | VARCHAR2(128) | NO | The name of the directory. |
| DIRECTORY_PATH | VARCHAR2(4000) | NO | The path of the directory. |
| ORIGIN_CON_ID | NUMBER(38) | NO | The tenant ID. |
Sample query
Query all directories accessible to the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_DIRECTORIES;
The query result is as follows:
+-------+----------------+----------------------+---------------+
| OWNER | DIRECTORY_NAME | DIRECTORY_PATH | ORIGIN_CON_ID |
+-------+----------------+----------------------+---------------+
| SYS | SQL_FILE_DIR | /home/admin/sqldump | 1004 |
+-------+----------------+----------------------+---------------+
1 row in set
References
Query all directories accessible to the current user: ALL_DIRECTORIES
For information about how to create and use directories, see Manage directories.