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-compatible 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.