DEV Community

Hisyam Johan
Hisyam Johan

Posted on • Edited on

Import Oracle DB Schema via Data Pump

#oracle11g

Continue from Export Oracle DB Schema via Data Pump. Now we want to import DB dumpfile.

  1. cd /u01/app/oracle/product/11.2.0.4/dbhome_1/bin
  2. Run this command to import dump file impdp directory=<dir.name> dumpfile=<dumpfile.name>.dmp logfile=<logfile.name>.log remap_schema='<schema.name>:<schema.name>'

Top comments (0)

Read next

yokewood6 profile image

Understanding the Significance of Cybersecurity

Miller Thompson -

wvnuola profile image

Home for the Holidays: Staying Ahead of Cybersecurity Threats

Wonuola Ogunsanmi -

afolabi_abdulsamad_52f6de profile image

Programming Problem Solving: C++ Case Study

Afolabi Abdulsamad -

raihanstark profile image

12 Projects In 12 Months Challenge

Raihan Yudo Saputra -