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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bricklen Anderson Sent: Friday, May 21, 2004 10:29 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: exporting directly from one server to another Paula_Stankus@xxxxxxxxxxxxxxx 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: //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------