Oracle教程 2023-02-23

Oracle 视图 ALL_DIRECTORIES 官方解释，作用，如何使用详细说明

？

ALL_DIRECTORIES 视图用来查看用户可以使用的目录信息（相当于文件夹）。比如目录名称，目录类型，用户可以访问的目录等等，都列在视图中。

使用方法：

— 查询当前可以访问的目录：
SELECT * FROM ALL_DIRECTORIES;

— 查询目录名为media/week_reports的信息：
SELECT * FROM ALL_DIRECTORIES WHERE directory_name=’media/week_reports’;

ALL_DIRECTORIES describes all directories accessible to the current user.

Related View

DBA_DIRECTORIES describes all directories in the database.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the directory (always `SYS`)
`DIRECTORY_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the directory
`DIRECTORY_PATH`	`VARCHAR2(4000)`		Operating system pathname for the directory
`ORIGIN_CON_ID`	`VARCHAR2(256)`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)