Synopsis
CREATE [OR REPLACE] DIRECTORY
directory_name
AS
'path_name
'
Creates a database directory object
(directory_name) that is used to store binary
large object (BLOB) files.
Keywords
- OR REPLACE
Can be used to redefine a directory object. If you use the OR REPLACE
function, all grants on the directory object are maintained.
- AS path_name
Specifies a valid filesystem directory on the current machine.
Notes
Oracle does not verify that the specified
path_name exists. Oracle will maintain the value
of path_name as specified for case-sensitive
filesystems.
Example
The following example creates a directory object named blob_dir:
CREATE DIRECTORY blob_dir AS '/u01/app/oracle/local/blob_dir'