How To Import Together With Export A Database Dump Inward Oracle

The next educational activity volition help us inward importing in addition to exporting our oracle database.

1. Create in addition to 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> practise 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 nosotros tin give the axe hold upwards 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