Collections:
Where Is the Export Dump File Located in Oracle
Where Is the Export Dump File Located in Oracle?
✍: FYIcenter.com
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".
⇒ Export Your Own Schema in Oracle
⇐ Perform a Full Database Export in Oracle
2016-10-15, 2438🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...