Finding Data Pump Dump Location in Oracle?

+1 vote
56 views
asked Apr 24 by Hitesh Garg (346 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 24 by Rahul Singh (518 points)  
selected Apr 30 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.

Welcome to Codingeek Q&A, where you can ask questions and receive answers from other members of the community.
...