Re: datapump export to pipe
- From: Fuad Habash <fmhabash@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Oct 2009 10:54:13 -0400
Let me propose an elgant way to do it. I always use it when needing to export a db on a host with scarce storage. I run my expdp in network mode. With this setup, I connect to db 1 on host 1 and create a link to db 2 on host 2 inside db 1. I then run expdp on host 1 using parameter 'network=link_to_db2. This causes db2 to get exported to a file on host 1 over the network. There are may exciting manuevers you can perform with the 'netwoek' params while importing or exporting. You can actually exp/imp from/to local/remote without ever needing to use a dump file. Hope this helps --------------- Thank You.
Other related posts:
- » datapump export to pipe - Tony Adolph
- » Re: datapump export to pipe - ~Jeff~
- » RE: datapump export to pipe - D'Hooge Freek
- » RE: datapump export to pipe - Riku Räsänen
- » Re: datapump export to pipe - Joey D'Antoni
- » Re: datapump export to pipe - Rich Jesse
- » Re: datapump export to pipe - Rich Jesse
- » Re: datapump export to pipe - Guillermo Alan Bort
- » Re: datapump export to pipe - Guillermo Alan Bort
- » Re: datapump export to pipe - Christoph
- » RE: datapump export to pipe - Powell, Mark D
- » RE: datapump export to pipe - Adams, Matthew (GE Indust, ConsInd)
- » RE: datapump export to pipe - Jost,
- » Re: datapump export to pipe - Jared Still
- » RE: datapump export to pipe - Rich Jesse
- » RE: datapump export to pipe - Powell, Mark D
- » Re: datapump export to pipe - Tony Adolph
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Robert Freeman
- » RE: datapump export to pipe - MacGregor, Ian A.
- » Re: datapump export to pipe - Rich Jesse
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Joey D'Antoni
- » Re: datapump export to pipe - Rich Jesse
- » Re: datapump export to pipe - Tony Adolph
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Adric Norris
- » Re: datapump export to pipe - Robert Freeman
- » Re: datapump export to pipe - Rich Jesse
- » RE: datapump export to pipe - Dunbar, Norman
- » RE: datapump export to pipe - Rich Jesse
- » RE: datapump export to pipe - Dunbar, Norman
- » RE: datapump export to pipe - Mercadante, Thomas F (LABOR)
- » RE: datapump export to pipe - Rich Jesse
- » Re: datapump export to pipe - Robert Freeman
- » RE: datapump export to pipe - Mercadante, Thomas F (LABOR)
- » Re: datapump export to pipe - Christoph
- » Re: datapump export to pipe - Rich Jesse
- » RE: datapump export to pipe - Rich Jesse
- » Re: datapump export to pipe - Jared Still
- » Re: datapump export to pipe - Christoph
- » Re: datapump export to pipe - Sanjay Mishra
- » Re: datapump export to pipe - Fuad Habash
- » RE: datapump export to pipe - Fmhabash
- » Re: datapump export to pipe - Tony Adolph
- » Re: datapump export to pipe - Kurt Franke
- » Re: datapump export to pipe - Sanjay Mishra
- » Re: datapump export to pipe - Tony Adolph