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, 2469🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...