Where Is the Export Dump File Located in Oracle

Q

Where Is the Export Dump File Located in Oracle?

✍: FYIcenter.com

A

If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump directory and locate the dump file.

>sqlplus /nolog

SQL> connect SYSTEM/fyicenter

SQL> COL owner FORMAT A8;
SQL> COL directory_name FORMAT A16;
SQL> COL directory_path FORMAT A40;
SQL> SELECT * FROM dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
----- -------------- -------------------------------------
SYS   DATA_PUMP_DIR  \oraclexe\app\oracle\admin\XE\dpdump\
SYS   TEST_DIR       /oraclexe/test
SYS   ORACLECLRDIR   \oraclexe\app\oracle\product\10.2.0\
                     server\bin\clr

Obviously, the default dump directory is directory object defined to \oraclexe\app\oracle\admin\XE\dpdump\. If you go to that directory, you will find the full database dump file is called "expdat.dmp".

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 223👍, 0💬