Re: DataPump Clients Over the Network: Some Complex Scenarios

From: Steve Harville <steve.harville_at_gmail.com>
Date: Thu, 9 Oct 2014 12:08:27 -0400
Message-ID: <CAGd4=DSoXAyVhzyA0KNpdnTNnLMWnDQb4hu=AMy2xBVkA4K0Pw_at_mail.gmail.com>

Hi Fred,
Is there any reason you need the dump file? If you don't need it just impdp directly into the target using a network_link. It still creates a log file but no dump file.

Steve Harville
<https://apex.appshosting.com/pls/apex/f?p=1076:steveharville>

On Thu, Oct 9, 2014 at 11:44 AM, Fred Habash <fmhabash_at_gmail.com> wrote:

> A datapump client needs to know 2 things. Where to put/read the dmp files
> and where the source schema is (to import or export from).
>
> The former is determined by specifying a connect identified 'expdp user_at_db',
> whereas the latter is determined by 'network_link'.
>
> It gets a little more complicated if you use both features. For example ...
>
> 1) export remote schema and put is on local host: expdp user/pwd
> network_link=remote_schema
>
> 2) export remote schema and put is on remote host: expdp user/pwd_at_remotedb
> remote_link=remote_schema
>
> There are mind-dizzying combination of this. There is one scenario I'm
> trying to accomplish and I can't. I do not think it is possible.
>
>
> export remote schema to local host dmp file and import to remote schema
> using same local host dmp.
>
> What do you think?
>
> Thank you ...
> ----------------------------------------
> Fred Habash, Database Solutions Architect (Oracle OCP 8i,9i,10g,11g)
>
>

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

Received on Thu Oct 09 2014 - 18:08:27 CEST