Re: Zero-cost on-the-fly compression for Data Pump expdp

From: Scott Sibert <ssibert_at_gmail.com>
Date: Mon, 22 Mar 2010 10:36:39 -0500
Message-ID: <9a600bbf1003220836j27f17de5m496f3adc5acb41cf_at_mail.gmail.com>

We upgraded to 11.2 from 9.2 (exp from 9.2 and imp into 11.2) and all our our scripts doing exports were, of course, using exp. In testing our existing scripts, we had issues with exp not exporting zero-extent tables from our 11.2 databases. We'd planned to go to expdp so we went ahead and changed the scripts to use expdp rather than seeing if there was something we could do to get the zero-extent tables.

expdp has a compression option that compresses exports quite well. Options are all, data_only, metadata_only and none. Works with parallel, so you can parallel=5 compression=all and each of those .dmp files will be compressed as they're created.

--Scott

On Mon, Mar 22, 2010 at 10:18 AM, Greg Rahn <greg_at_structureddata.org> wrote:

> Exp/Imp are still in 11.2.
>
> "The Data Pump utility enables you to archive data and to move data
> between one Oracle Database and another. Also available are the
> original Import (IMP) and Export (EXP) utilities for importing and
> exporting data from and to earlier releases."
>
> http://download.oracle.com/docs/cd/E11882_01/server.112/e10595/dba008.htm#ADMIN11067
>
> On Mon, Mar 22, 2010 at 8:12 AM, Rich Jesse
> <rjoralist_at_society.servebeer.com> wrote:
> > In a more constructive post (ahem), I'm struggling with the eventual loss
> of
> > on-the-fly compression for our database refreshes since we currently use
> exp
> > to a Unix FIFO device that is directed to gzip. Simple and elegant, but
> > it's going away (11gR2?).
>
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 22 2010 - 10:36:39 CDT