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).
Join the DZone community and get the full member experience.
Join For FreeHere 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
Published at DZone with permission of Zemian Deng, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
Comments