set heading off 
set verify off 
set feedback off 

spool ext_dirs.sql 


select distinct 'create directory '||DIRECTORY_NAME||' as '''||DIRECTORY_PATH||''' ;' from all_directories, dba_tab_Privs where DIRECTORY_NAME = TABLE_NAME and grantee=(select user from dual); 

spool off