SELECT t.privilege,t.grantee,t.grantor, d.directory_name, d.directory_path
FROM user_tab_privs t, all_directories d 
WHERE t.table_name(+)=d.directory_name
--AND   d.directory_name in ('DTPUMP') ORDER BY 2,1;

select * from dba_directories

/*
select * from dba_datapump_jobs
select * from dba_datapump_sessions
select * from dba_tables where table_name like '%VS0%'
-- para elimar uma sess?o de expdp, que foi cancelada de forma n?o convencional é necessário elinar a tabela que consta no campo Job_name da dba_datapump_jobs
-- drop table sys.vs01
drop directory DT_VS01;
create directory dt_vs01 as '/u02/backup';
grant write, read on directory dt_vs01 to EXP_FULL_DATABASE;
grant write, read on directory dt_vs01 to IMP_FULL_DATABASE;
*/

/* DUMPS
-- =======================================================================
expdp dumpfile=Arquivo.dmp logfile=Arquivo_exp.log schemas=SCHEMA directory=DUMP_DIR compression=all consistent=y
impdp dumpfile=Arquivo.dmp logfile=Arquivo_imp.log schemas=SCHEMA directory=DUMP_DIR
======================================================================= */