Oracle Directories

Step 1: Allow user to create any directory in database.

GRANT CREATE ANY DIRECTORY TO scott;

GRANT DROP ANY DIRECTORY TO scott;

Step 2: Create directory.


CREATE OR REPLACE DIRECTORY temp AS '/d08/temp';

Step 3: Give access to the directory.

GRANT READ, WRITE ON DIRECTORY temp TO scott;

optional: (REVOKE WRITE ON DIRECTORY tmp FROM scott)

Step 4: View database directories.

SELECT  *
   FROM all_directories;

Note: You must have DBA rights, if you don't have DBA rights, you will get an error 
"Invalid Directory Path".

Related Posts:

• Move BLOB files into Oracle Directory
• Check if file exists in Oracle Directory