Note
This view is available starting with V3.2.1.
Purpose
This view displays all directories accessible to the current user.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Purpose
| 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 that the current user can access.
obclient [SYS]> SELECT * FROM SYS.ALL_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
To view all directories in the current tenant, see DBA_DIRECTORIES.
For information about how to create and use directories, see Manage directories.