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)