Re: datapump export to pipe

From: Robert Freeman <>
Date: Tue, 6 Oct 2009 13:46:25 -0700 (PDT)
Message-ID: <>

Yep, exp is still there in release 2 also... I'd guess it will be around for a while. Imp is to be deprecated in 12. So maybe both go away in 13.. or 12R2...

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles

From: "Powell, Mark D" <> To:
Sent: Tue, October 6, 2009 10:40:25 AM
Subject: RE: datapump export to pipe

Yes, it looks like the material I got the information from was/is wrong. I checked the 11gR1 documentation and the Utilities manual still has one chapter on both exp and imp. It does state, "Original export is desupported for general use as of Oracle Database 11g." which is not the same as not being included.  

  • Mark D Powell -- HP Enterprise Services Phone (313) 592-5148

 From: Jared Still []
>Sent: Tuesday, October 06, 2009 12:25 PM
>To: Powell, Mark
> D
>Subject: Re: datapump export
> to pipe
>On Tue, Oct 6, 2009 at 8:48 AM, Powell, Mark D <> >wrote:
>> regular export. <<
>>Not with
>> 11g. Only imp is provided to allow loading old exp dmp files into the
>> database. The exp utility is now history though I am sure a lot
>> of sites running 10g and lower will still be using exp for a few
>> more years.
>Version and platform?
>I just checked on linux, and exp is still available.
>exp help=y
>Export: Release - Production on Tue Oct 6 09:19:48 2009
>Copyright (c) 1982, 2007, Oracle. All rights reserved.
>I have not yet installed 11gR2 to check it.
>Jared Still
>Certifiable Oracle DBA and Part Time Perl
> Evangelist
>Oracle Blog:
> Page:
Received on Tue Oct 06 2009 - 15:46:25 CDT

Original text of this message