RE: Data Pump and compression
- From: "Fedock, John \(KAM.RIC\)" <John.Fedock@xxxxxxxxxxxx>
- To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Oct 2007 13:29:16 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman
Sent: Friday, September 28, 2007 10:12 AM
To: Michael.Kline@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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!
RF
--- "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
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)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
