	AllExperts > Oracle
	Search

Volunteer
Answers to thousands of questions

Home · More Oracle Questions · Answer Library

· Encyclopedia ·

Oracle - impdp/expdp problem

Expert: Peter Choi - 9/29/2009

Question
I am using window server 2003 sp 1 and oracle 10g. When I am trying to import database using IMPDP utility. Can you explain using simple steps to use impdp and expdp utilites.

Answer
Hi Hari,

As you know, starting with Oracle 10g and higher, Oracle is recommending the use of the DataPump utility to replace the Export/Import utilities. It should be noted that once you create a .dmp file using datapump, it is NOT backwards compatible with Export/Import.

From this point onwards, we will refer to the DataPump Export (EXPDP) and DataPump Import (IMPDP) tools.

To get some help on the syntax, on the command line type

> expdp -?
or
> impdp -?

The most basic command could look like this:

> expdp <user>/<password>@<database_instance> parm=[parm1] parm2=[parm2] ...

example1: expdp hr/hr DIRECTORY=dpump_dir2 DUMPFILE=expfull.dmp FULL=y NOLOGFILE=y
example2: expdp hr/hr@inst1 DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp TABLES=employees

example3: impdp hr/hr DUMPFILE=dpump_dir1:expfull.dmp FULL=y LOGFILE=dpump_dir2:full_imp.log
example4: mpdp hr/hr@inst1 DIRECTORY=dpump_dir DUMPFILE=hr.dmp TABLES=employees

Enclosed are the references which you will find useful.

Reference 1: http://www.oracle.com/technology/obe/obe10gdb/storage/datapump/datapump.htm
Reference 2: http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
Reference 3: http://www.orafaq.com/wiki/Datapump
Reference 4: http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Hope this helps.

Peter

Add to this Answer Ask a Question