Oracle Database 12c/19c: SQL query to get DDL of DBA_DIRECTORIES

 Oracle Database 12c/19c: SQL query to get DDL of DBA_DIRECTORIES

connect sqlplus as sysdba and run below query:

set long 999999999

SELECT 
  'CREATE OR REPLACE DIRECTORY ' || directory_name || ' AS ' || '''' ||
    REPLACE(directory_path, '/old', '/new') || '''' || ';' FROM  dba_directories 
WHERE directory_name IN (select directory_name from dba_directories);