RE: Example of expdp/impdp over network?

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_at_credit-suisse.com] 
Sent: Wednesday, April 05, 2006 2:04 PM
To: Bobak, Mark; oracle-l_at_freelists.org
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_at_credit-suisse.com 
212.538.1143 

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark
	Sent: Wednesday, April 05, 2006 12:26 PM
	To: oracle-l_at_freelists.org
	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


========================================================================

======


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