Welcome! This is a website that everyone can build together. It's easy!

Data Import and Export

Oracle provides several methods which one can use to perform logical database backup and recovery. Of these, the common utilities used are the import and export tools. Many times they are used to move schema definitions and data between different Oracle instances and users.

While still supported on 10g the original import (imp) and export (exp) utilities were replaced in 10g with the faster and more advanced Data Pump-based, impdp and expdp.

On 11g just imp will be still available, so if you using 10g, now is the time to starting using data pump.

If you're using Oracle9i or earlier, and are looking for more information on using the original utilities, see this page. If you're using 10g or 11g, more information on the Data Pump-based utilities can be found here.


Latest page update: made by HelioDias , Nov 30 2007, 12:10 PM EST (about this update About This Update HelioDias 11g imp deprecated - HelioDias

1 word added
1 word deleted

view changes

- complete history)
Keyword tags: data exp expdp export imp impdp import
More Info: links to this page

Anonymous  (Get credit for your thread)


Started By Thread Subject Replies Last Post
Alain.B. Expdp Client side ? 1 Aug 22 2008, 2:31 AM EDT by astephan
Alain.B.
Thread started: Aug 20 2008, 5:10 AM EDT  Watch
Is there a way to use expdp from any client station and having the dumpfile also generated on that same station ?
Like old exp ?
2  out of 2 found this valuable. Do you?    
Keyword tags: client side exp expdp export
Show Last Reply
psmith@epx.com Data Pump.....and Compression? 4 Jan 25 2008, 1:38 PM EST by rucknrun
psmith@epx.com
Thread started: Dec 17 2007, 3:58 PM EST  Watch
A common technique used with exp/imp was compressing through a Pipe. Apparently this cannot be done with data pump "the ... dumpfile ... is no longer processed in a sequential manner" (Note:463336.1).

Certainly understandable up to the point of output to the named DUMPFILE...but beyond that point isn't this a fundamental violation of the accepted handling of Files in an UNIX environment? The specified DUMPFILE doesn't comply with what I've always understood to be the basic rules of Files in UNIX. Perhaps it might make some sense to allow the DUMPFILE one additional level of abstraction by using a BLOB or External Table for non-sequential assembly, the attaching this to a Standard File output which would adhere to the traditional conventions...once again allowing use of Pipes! Just an idea.....
1  out of 14 found this valuable. Do you?    
Keyword tags: data exp expdp export imp impdp import
Show Last Reply

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Site pages
Top Contributors