RE: exporting directly from one server to another

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 21 May 2004 15:37:42 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFCDC@bosmail00.bos.il.pqe>

>From memory, it's been a while since I did this,=20
it goes something like this:

login to destination server:
mknod destination_pipe p
imp file=3Ddestination_pipe <other import options> (now import is blocking on the pipe, waiting for data to arrive. It will patiently wait till it starts receiving data.)

login to source server:
mknod source_pipe p
cat source_pipe | ssh destination_server cat >> destination_pipe (Now the cat and the ssh are blocking on input to the source_pipe.) Finally:
exp file=3Dsource_pipe <other export options>

And you should see the export take off on the source box and a few seconds later, see an import take off on the destination box.

Hope that helps,

-Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rachel Carmichael Sent: Friday, May 21, 2004 3:23 PM
To: oracle-l_at_freelists.org
Subject: RE: exporting directly from one server to another

Ruth, I love you but that script doesn't do what Paula wants. And it was written for 7.3!

Paula -- just this month there was a discussion on the list about this. I can't remember offhand who posted the exact instructions, but I'm fairly sure someone did. If you search the archives you'll likely find the information

Rachel

• Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
  > Paula,
  > There is a procedure that I got from Rachel Carmichael to do this but
  > I
  > don't think I have the original anymore. I used it a couple of times
  > going
  > when I was changing block size etc. I will try to find it on Monday
  > and
  > post it for you. If not, just write to her and ask her. I know she
  > will be
  > happy to send it to you. If your database is really big, exp/imp is
  > really
  > not a good option. This time I migrated my 8063 to 9024 and it was a
  > snap
  > (except for the mistake that Oracle Support made, but that is another
  > story).
  >=20
  > If you want me to find it let me know!
  >=20
  > Regards,
  > Ruth
  >
  

=09

        =09

---

Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer=20

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 21 2004 - 14:34:43 CDT