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 Blog: http://robertgfreeman.blogspot.com ________________________________ From: "Powell, Mark D" <mark.powell@xxxxxxx> To: oracle-l@xxxxxxxxxxxxx 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 [mailto:jkstill@xxxxxxxxx] > >Sent: Tuesday, October 06, 2009 12:25 PM >To: Powell, Mark > D >Cc: oracle-l@xxxxxxxxxxxxx >Subject: Re: datapump export > to pipe > > >On Tue, Oct 6, 2009 at 8:48 AM, Powell, Mark D <mark.powell@xxxxxxx> >wrote: > >>> >> Oracle STILL PROVIDES >> 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 11.1.0.7 on linux, and exp is still available. >exp help=y > > >Export: Release 11.1.0.7.0 - 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: http://jkstill.blogspot.com >Home > Page: http://jaredstill.com