RE: Data Pump and compression

From: Fedock, John \(KAM.RIC\) <John.Fedock_at_us.kline.com>
Date: Mon, 1 Oct 2007 13:29:16 -0400
Message-ID: <5042FDC675779848A113F70D54F587491A82F847@KAMRICEXCLUS.us.kline.com>

As a FYI, you can use the network_link option using an import and this will import data into database A thru a link connecting to database B. No need to have the data go to disk first. I have done this recently and it was very nice. Only downside is there is no "commit" option, so I had to break up my 9GB of data into smaller ranges.

Hope this helps.

John Fedock

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman Sent: Friday, September 28, 2007 10:12 AM To: Michael.Kline_at_SunTrust.com; oracle-l_at_freelists.org Subject: Re: Data Pump and compression

Datapump in 11g does support compression and works quite well.

What I'm not sure about is if you must own the license for compression to use it.

More Oracle 11g new features like this one in my forth coming book from Oracle Press, Oracle Database 11g New Features.

Cheers!

"Kline.Michael" <Michael.Kline_at_SunTrust.com> wrote:

> Has any one heard if 11G Data Pump is going to
> support compression?
>
> In some cases, while we would love to go to data
> pump, we don't have the
> disk to hold it until it gets compressed.
>
> Michael Kline
> Database Administration
> Richmond, Va. 23227
> BlackBerry: 804.517.7443
>
>
>
> LEGAL DISCLAIMER
> The information transmitted is intended solely for
> the individual or entity to which it is addressed
> and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination
> or other use of or taking action in reliance upon
> this information by persons or entities other than
> the intended recipient is prohibited. If you have
> received this email in error please contact the
> sender and delete the material from any computer.
>
> SunTrust and Seeing beyond money are federally
> registered service marks of SunTrust Banks, Inc.
> [ST:XCL]
>
>
>
>
>

Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!

Oracle Database 11g New Features (Oracle Press)

Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

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



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

Received on Mon Oct 01 2007 - 12:29:16 CDT