RE: exporting directly from one server to another

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 21 May 2004 15:02:24 -0400
Message-ID: <003f01c43f66$26ce12b0$8459699f@vttaxnet.tax.state.vt.us>

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).

If you want me to find it let me know!

Regards,
Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bricklen Anderson   Sent: Friday, May 21, 2004 10:29 AM
  To: oracle-l_at_freelists.org
  Subject: Re: exporting directly from one server to another

Paula_Stankus_at_doh.state.fl.us wrote:

> Guys,
>
> I am upgrading an 8.0.6 database to 9i with an export/import.
It is a =
> 24x7 high input system. I remember coming across a method a long long =
> time ago that allowed you to export through a pipe directly to another =
> box as being fast as heck. Was I dreaming this?
>
> Thanks,
> Paula

Topic came up recently:
http://www.freelists.org/archives/oracle-l/05-2004/msg00570.html

  --
  Bricklen Anderson, Database Administrator   PresiNET Systems
  http://www.PresiNET.com
  Main: (250) 405-5380
  Online Demo: https://www.presinet.com/secure/login

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than the intended recipient is unauthorized. If you have received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

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 - 13:59:30 CDT