oracle directories - ghdrako/doc_snipets GitHub Wiki

Info

select * from all_directories;

Create

CREATE OR REPLACE DIRECTORY dump_csv AS '/u01/oradata/slog/app/exp/dump_csv';
GRANT READ ON DIRECTORY dump_csv  TO esga;
GRANT WRITE ON DIRECTORY dump_csv TO esga;

Drop

DROP DIRECTORY ctemp;