How to Import a Oracle Database Dump File

Here is an example on how to import a Oracle database dump file (a binary file that's exported from a Oracle database using the Oracle data pump utility). For this instruction example, let's say I was given a myapp.dmp.gz file.

NOTE: If you do not use the same db user/tablespace for export and import, then you need to know its names used during export to perform the remapping during import.

Step 1: If you don't have an Oracle database instance to work with, create one.

Step 2: Create a new db user in a Oracle database instance. The easiest way to do this is to use the SqlDeveloper tool and use the "Create New User" dialog prompt. (For this example, I will call my new user  MYAPP08182015, password Password1, and tablespace named MY_TABLE_SPACE.)

Step 3: Now you have a new db User (Schema) and password, you may start the data import using the command line prompt. Ssh into the database server where you can find the impdp command utility.

scp myapp.dmp.gz zemian@mydbserver:/tmp

ssh zemian@mydbserver

cd /tmp

gunzip myapp.dmp.gz

/app/oracle/dbhome/bin/ impdp MYAPP08182015/Password1 REMAP_SCHEMA=MYAPP:MYAPP08182015 REMAP_TABLESPACE=USERS:MY_TABLE_SPACE LOGFILE=/tmp/myapp.dmp.log DUMPFILE=/tmp/myapp.dmp