dba_directories lists all directories. dba_directories, all_directories and cdb_directories. declare
syml pls_integer;
begin
for dir in (
select
directory_name name,
directory_path path
from
dba_directories
order by
lower(directory_path)
)
loop
dbms_output.put_line(
rpad(dir.name, 31) ||
rpad(dir.path, 100) ||
case when dbms_utility.directory_has_symlink(dir.name) =
dbms_utility.has_symlink then 'symlink'
else 'nosymlink'
end
);
end loop;
end;
/