CREATE AND GRANT ACCESS TO DIRECTORY IN ORACLE
Create a logical directory on database
SQL> create directory dpexp as '/home/oracle'; Directory created.
Grant the both read and write privileges to access the directory for a user
SQL> grant read,write on directory dpexp to hr; Grant succeeded.
To modify the path of the existing directory
SQL> create or replace directory dpexp as '/home'; Directory created.