_____________________________________________________________________________________

set pages 1000
set lines 200
col directory_name for a25
col directory_path for a150
select directory_name, directory_path from dba_directories order by 1;


set pages 1000
set lines 200
col grantee   for a15
col directory for a15
col privilege for a5
select grantee, table_name "DIRECTORY", privilege from dba_tab_privs
 where table_name in ('MIG_LOG_DIR','REORG')
 order by 1, 2, 3;
_____________________________________________________________________________________