no

How to Import and Export a Database Dump in Oracle

The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.datab...


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

Related

rdbms 4285213295383889375

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item