See all external directories in Oracle 10g

Took me a while to find this – I knew it had to be there but couldn’t find the view to query – so I thought I’d post this info.  Every data pump article I found listed how to create a directory, but not how to make sure there wasn’t already one set up for the directory you wanted.  Finally found a good article on logical directories.  To see all directories in the database, query the dictionary view ‘all_directories’.

select * from all_directories;

Leave a comment