CODEWITHSUNDEEP
oracle-databaseutl-file
PRIYA GOUR
PRIYA GOUR

Reputation: 11

Can we find out directory name , path and other details related to files in oracle? If yes, what is the query for that?

SELECT * FROM DBA_DIRECTORIES; --gives all list of directory in database.
select * from DBMS_CLOUD.LIST_FILES('tmp'); --gives detail about files in tmp directory.

Can we find out directory name, path and other details related to files in oracle?
If yes, what is the query for that?

Upvotes: 0

Views: 2114

Answers (1)

Aleksandr Chehrov
Aleksandr Chehrov

Reputation: 21

I could be wrong, but most probably you are looking for this SQL:

SELECT * FROM DBA_DATA_FILES;

Please see this post for more details: How to find the default location in which Oracle DBF files are created?

Upvotes: 2

Related Questions