Name

CREATE DIRECTORY

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'
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset