Where Is the Export Dump File Located?
Submitted by: AdministratorIf 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/globalguideline
SQL> COL owner FORMAT A8;
SQL> COL directory_name FORMAT A16;
SQL> COL directory_path FORMAT A40;
SQL> SELECT * FROM dba_directories;
<pre>OWNER DIRECTORY_NAME DIRECTORY_PATH
----- -------------- -------------------------------------
SYS DATA_PUMP_DIR oraclexeapporacleadminXEdpdump
SYS TEST_DIR /oraclexe/test
SYS ORACLECLRDIR oraclexeapporacleproduct10.2.0
serverinclr</pre>
Obviously, the default dump directory is directory object defined to oraclexeapporacleadminXEdpdump. If you go to that directory, you will find the full database dump file is called "expdat.dmp".
Submitted by: Administrator
>sqlplus /nolog
SQL> connect SYSTEM/globalguideline
SQL> COL owner FORMAT A8;
SQL> COL directory_name FORMAT A16;
SQL> COL directory_path FORMAT A40;
SQL> SELECT * FROM dba_directories;
<pre>OWNER DIRECTORY_NAME DIRECTORY_PATH
----- -------------- -------------------------------------
SYS DATA_PUMP_DIR oraclexeapporacleadminXEdpdump
SYS TEST_DIR /oraclexe/test
SYS ORACLECLRDIR oraclexeapporacleproduct10.2.0
serverinclr</pre>
Obviously, the default dump directory is directory object defined to oraclexeapporacleadminXEdpdump. If you go to that directory, you will find the full database dump file is called "expdat.dmp".
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | What Is the Relation of a User Account and a Schema? |
☺ | How To Retrieve Data from an Explicit Cursor? |
☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
☺ | How To Recover a Dropped Table in Oracle? |
☺ | What Is Input Buffer in SQL*Plus? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |