Re: Data Pump and compression

  • From: Bala <oratips@xxxxxxxxx>
  • To: John.Fedock@xxxxxxxxxxxx
  • Date: Mon, 3 Nov 2008 11:56:29 -0500

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@xxxxxxxxxxxx> 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@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
>
>

Other related posts: