To create a directory:
CREATE OR REPLACE DIRECTORY EXT_TABS AS 'C:\ext_tab_files';
Using REPLACE when creating objects is not a good idea as it can wipe out existing objects, so be careful.
To list all directories in the database:
SELECT * FROM all_directories;
OR
SELECT * FROM dba_directories;
Directory privileges can be viewed using the one of the queries below:
SELECT * FROM all_tab_privs WHERE table_name = 'EXT_TABS';
One thing to remember is directories are listed as tables, i was assuming they would be a object of their own.
This blog is for my reference, if you plan to use any information in here do research before blindly implementing it.
