Create Directory Path on Oracle Database

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>:

Leave a Comment.