Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Using Named Pipes on Windows
The reason for using named pipes is speed, not disk space.
Reading the import directly from a pipe is much faster then writing to
disk
and then reading the same data from disk.
It doesn't matter now anyway, I've discovered that it cannot be done on windows.
Yet another Windoze limitation. It's ridiculous.
Jared
"Indy Johal" <Indy_Johal_at_prnewswire.com>
Sent by: root_at_fatcity.com
05/16/2003 07:21 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: Re: Using Named Pipes on Windows
Jared
Is there any reason to use Named Pipe. If the reason is due to Export dump limitation of big file and then why you are not considering the use of Export Option of Multiple filename along with Filesize parameter. That can take care of your File size limitation as well as Export Dump limitation.
Indy Johal
Jared.Still_at_radisys.com
Sent by: root_at_fatcity.com
05/15/03 07:06 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: Using Named Pipes on Windows
Most of us have used named pipe on unix with export/import, it's fairly easy.
Has anyone done this with named pipes on Windows 2000/NT? ( not as easy )
I'm considering putting together scripts to use exp/imp with Win2k named pipes to move some data ( 200 gig ) for a system upgrade.
If I can do this in a reasonable amount of time ( < 1 day ) using parallel exp/imp jobs and named pipes, it would allow us to get off of DD managed tablespaces during the course of our data migration.
Otherwise it's the old copy the data files routine, and reorg later to get
LMT's.
If you've done this, would you mind sharing your experiences with it?
Thanks,
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 16 2003 - 13:40:46 CDT