How to Import and Export a Database Dump in Oracle

The following instruction will help us in importing and exporting our oracle database.

1. Create and restore dump file (http://www.database.fi/2011/05/using-expdp-and-impdp-export-and-import-in-10g-11g/)
1. Create dump file
1. sqlplus system/oracle
2. SQL> create directory dmpdir AS 'c:\temp';
3. select directory_name, directory_path from dba_directories;
4. expdp system/password version=’10.2.0.1’ dumpfile=czetsuya.dmp directory=dmpdir schemas=czetsuya
2. Restore a dump file
1. For import we can use the DATA_PUMP_DIR setting:
1. ORACLE_XE\app\oracle\admin\XE\dpdump
2. Copy dump file to folder above
3. impdp system/password dumpfile=czetsuya.dmp directory=DATA_PUMP_DIR full=y logfile=czetsuya.log