Consultar una RUTA de un directorio
SELECT directory_path FROM dba_directories
WHERE directory_name =`direct_01`;
Crear DIRECTORIOS o cambiarlos de ruta
CREATE OR REPLACE DIRECTORY BDUMP AS
'RUTA_DE_MI_DIRECTORIO_FISICO';
CREATE OR REPLACE DIRECTORY direct_01 AS '/backup';
GRANT READ, WRITE ON DIRECTORY direct_01 TO system;
Conocer los directorios de la BD
select * from dba_directories;
select directory_path from dba_directories;
select directory_path from dba_directories where directory_name='directorio01';