Skip to content

DEV Community

Hisyam Johan

Posted on Dec 24, 2021 • Edited on Jun 28, 2024

Import Oracle DB Schema via Data Pump

#oracle11g

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

cd /u01/app/oracle/product/11.2.0.4/dbhome_1/bin
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)

Subscribe

Create up to 10 Postgres Databases on Neon's free plan.

If you're starting a new project, Neon has got your databases covered. No credit cards. No trials. No getting in your way.

Try Neon for Free →

Read next

Exploring Open Source Licensing Models in the Blockchain Era: A Deep Dive

Rachel Duncan - Mar 5

Navigating the Intricate World of Open Source Licensing in Cyberwarfare

kallileiser - Mar 5

Navigating the Maze of Open Source Licensing: Challenges and Solutions

Ahmend Riss - Mar 5

Zentral: Your New Best Friend for System Event Monitoring

GitHubOpenSource - Mar 5