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