How to retrieve an Oracle directory path

Question

I created the following Oracle Directory csvDir   create or replace directory csvDir as   d  oracle oradata external data downloadedFiles     Now  how can I retrieve the path from this csvDir alias   There should be some system table that stores this path

User · Accepted Answer

That would be the ALL DIRECTORIES view   http   download oracle com docs cd B28359 01 server 111 b28320 statviews 1075 htm i1576965

User · Answer

The ALL DIRECTORIES data dictionary view will have information about all the directories that you have access to  That includes the operating system path  SELECT owner  directory name  directory path   FROM all directories

User · Answer

select directory path from dba directories where upper directory name     CSVDIR

[oracle] How to retrieve an Oracle directory path?

Examples related to oracle

Examples related to directory