| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ALL_DIRECTORIES describes all directories accessible to the current user.
DBA_DIRECTORIES describes all directories in the database.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
OWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the directory (always SYS) | 
DIRECTORY_NAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the directory | 
DIRECTORY_PATH | 
VARCHAR2(4000) | 
Operating system pathname for the directory |