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

MariaDB TX, proven in production and driven by the community, is a complete database solution for any and every enterprise — a modern database for modern applications.

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



MariaDB AX is an open source database for modern analytics: distributed, columnar and easy to use.

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 }}