Directory is important on oracle for backup and upload data. To manage directory on Oracle as follows :
Creating Directory :
CREATE DIRECTORY <directoryname> AS 'oracle/admin';
Create Or Replace Directory :
CREATE OR REPLACE DIRECTORY <directoryname> AS '/oracle/admin';
Grant Directory to User Access :
GRANT READ, WRITE ON DIRECTORY <directoryname> TO <userschema>:
www.diarycoding.com