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.