Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

How to Import a Oracle Database Dump File

DZone's Guide to

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).

· Database Zone ·
Free Resource

Built by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.  

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



Download AnzoGraph now and find out for yourself why it is acknowledged as the most complete all-in-one data warehouse for BI style and graph analytics.  

Topics:
relational database ,oracle ,database ,sql ,dump file

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}