| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Using Named Pipes on Windows
Thanks for the link Chris.
I've already seen it however.
Yes, named pipes work on Windows, but not easily from the command line ( there is no mknod p or mkfifo in Windows AFAIK ), and not at all with Oracle's export and import utilities.
They can be made to work with sqlloader, but only with fixed length records. At that, you must write a program in C or Perl to set up the pipe.
This is documented by Oracle. I've also tried it. exp/imp don't work with named pipe on windoze.
Jared
"Chris Berry" <compjma_at_hotmail.com>
Sent by: root_at_fatcity.com
05/20/2003 03:06 PM
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
>From: Jared.Still_at_radisys.com
>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
I think someone may have fed you some bad info, named pipes do work on windows, just a little differently, check this link out for more info:
http://www-106.ibm.com/developerworks/linux/library/l-rt4/?open&t=grl,l=252,p=pipes
Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates
"All I want is a few minutes alone with the source code for the universe
and
a quick recompile."
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry INET: compjma_at_hotmail.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 Tue May 20 2003 - 18:16:50 CDT
 |
 |