Finding Data Pump Dump Location in Oracle?

Question

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.

Answer 1

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.