Re: datapump export to pipe
From: Fuad Habash <fmhabash_at_gmail.com>
Date: Fri, 9 Oct 2009 10:54:13 -0400
Message-ID: <db523fc50910090754r101b9af1pc853abb1856e2279_at_mail.gmail.com>
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.
Thank You.
Date: Fri, 9 Oct 2009 10:54:13 -0400
Message-ID: <db523fc50910090754r101b9af1pc853abb1856e2279_at_mail.gmail.com>
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 09 2009 - 09:54:13 CDT