The ALL_DIRECTORIES view provides the information about all directories created by the CREATE DIRECTORY command.

Parameter Type Description
owner CHARACTER VARYING(30) The username of the owner to which the directory belongs.
Directory_name CHARACTER VARYING(30) The alias name assigned to the directory.
directory_path CHARACTER VARYING(4000) The path to the directory.