Re: Data Pump and compression

Hello John,

Thanks for your excellent posting.

Environment : 10.2.0.4 on HP-UX.

1. Can we use network_link from TEST instance to connect to UAT to refresh entire TEST instance ?
2. What to specifiy for DIRECTORY --
3. How to break up into smaller ranges since there is no commit option ? -- Thanks for your inputs.

Best regards
Bala

On Mon, Oct 1, 2007 at 12:29 PM, Fedock, John (KAM.RIC) < John.Fedock_at_us.kline.com> wrote:

>
> 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!
>
> RF
>
>

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