How to create an Oracle Directory

CREATE OR REPLACE DIRECTORY <<DIRECTORY_NAME>> AS '<<PATH>>';

Example:

CREATE OR REPLACE DIRECTORY RMAX_OUT_DIR AS '/vol1/out/docs';

Example .cdb file:

-----------------------------------------------------------------------
--  Module : CMOD
--
--  File   : db_dir_create.cdb
--
--  Date    Sign     History
--  ------  -------  --------------------------------------------------
--  000000  RMAX     Created
--  ------  -------  --------------------------------------------------
-----------------------------------------------------------------------

PROMPT Create oracle directories NAMED RMAX_OUT_DIR_<DB_NAME> and RMAX_OUT_BKP_DIR_<DB_NAME>

DECLARE
   sql_stmt_       VARCHAR2(32000);
   dir_path_       VARCHAR2(2000);
   bkp_dir_path_   VARCHAR2(2000);
   db_name_        VARCHAR2(100);
BEGIN
   db_name_      := UPPER(Sys_Context('USERENV', 'DB_NAME'));
   dir_path_     := '/vol1/' || LOWER(db_name_) || '/out/docs';
   bkp_dir_path_ := '/vol1/' || LOWER(db_name_) || '/out/docs/backup';
   
   sql_stmt_ := 'CREATE OR REPLACE DIRECTORY RMAX_OUT_DIR_' || db_name_ || ' AS ''' || dir_path_ || '''';
   EXECUTE IMMEDIATE sql_stmt_;
   
   sql_stmt_ := 'CREATE OR REPLACE DIRECTORY RMAX_OUT_BKP_DIR_' || db_name_ || ' AS ''' || bkp_dir_path_ || '''';
   EXECUTE IMMEDIATE sql_stmt_;
END;
/

COMMIT;
/