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
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)