Finding Data Pump Dump Location in Oracle?

+1 vote
asked Apr 23, 2018 by Hitesh Garg (799 points)  

I have created a database dump using the data pump but I am unable to find the location of the created database dump.
It simply shows that it is saved in the mentioned location of DATAPUMPDIR.
How to find the location of this dircetory.

1 Answer

+1 vote
answered Apr 23, 2018 by Rahul Singh (682 points)  
selected Apr 29, 2018 by Hitesh Garg
Best answer

This can be done using a very simple and a basic sql command. Try the below command.

select DIRECTORY_PATH from dba_directories where directory_name='DATA_PUMP_DIR';

This will give the path of created dump.