RE: Example of expdp/impdp over network?

From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 5 Apr 2006 14:13:03 -0400

Thanks Paul, that's what I thought.  In fact, if you're doing it over
the network, I don't think you even need the directory= parameter.
 
Anyhow, that's what I'm testing.  But, while not knowing what I was
doing, I screwed up my target database, so, I'm recreating it, and then
I'm going to start fresh.  Live and learn.
 
Thanks!
 
-Mark
 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled.  --Richard P. Feynman, 1918-1988

 

________________________________

From: Baumgartel, Paul [mailto:paul.baumgartel@xxxxxxxxxxxxxxxxx] 
Sent: Wednesday, April 05, 2006 2:04 PM
To: Bobak, Mark; oracle-l@xxxxxxxxxxxxx
Subject: RE: Example of expdp/impdp over network?


Mark,
 
Yes, indeed.  
 
Create a dblink on the destination database.  Then:
 
impdp user/pass directory=<directory> logfile=<logfile>
network_link=<the dblink> ...etc. etc.
 
Paul Baumgartel 
paul.baumgartel@xxxxxxxxxxxxxxxxx 
212.538.1143 

        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bobak, Mark
        Sent: Wednesday, April 05, 2006 12:26 PM
        To: oracle-l@xxxxxxxxxxxxx
        Subject: Example of expdp/impdp over network?
        
        

        Hi, 

        Does anyone have a simple example of how to use expdp/impdp to
get data from one 10G database to another via a network link, without
writing an intermediate file?

        I did some slogging throughg the Utilities manual and some
Google searches, but no luck yet. 

        AdvThanksance, 

        -Mark 

        -- 
        Mark J. Bobak 
        Senior Oracle Architect 
        ProQuest Information & Learning 

        For a successful technology, reality must take precedence over
public relations, for Nature cannot be fooled.  --Richard P. Feynman,
1918-1988


========================================================================
======
Please access the attached hyperlink for an important electronic
communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
========================================================================
======

RE: Example of expdp/impdp over network?

Other related posts: