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
How to import and export a database dump in oracle How to import and export a database dump in oracle Reviewed by Edward Legaspi on Saturday, July 12, 2014 Rating: 5

No comments:

Powered by Blogger.