| 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
Here's the explanation from Oracle, found in note 1013617.102
Under Windows NT, you cannot use a blocking pipe with Oracle server tools
since
they use the C runtime library for file i/o operations. The C runtime
routines
as implemented under Windows NT will not block when reading from a pipe,
only
the Windows API file i/o routine ReadFile() will. To workaround this
problem we
have to make use of the FIX option for the INFILE parameter of the control
file.
This is for SQL Loader, there is no workaround for exp/imp AFIK.
Jared
Paula_Stankus_at_doh.state.fl.us
Sent by: root_at_fatcity.com
05/16/2003 12:11 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
Dear Jared,
Was it an Oracle on Windows limitation or simply a Windows limitation and
why - if you don't mind.
Thanks,
Paula
Oracle OCP DBA
-----Original Message-----
Sent: Friday, May 16, 2003 2:41 PM
To: Multiple recipients of list ORACLE-L
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).
--
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 - 14:57:25 CDT
 |
 |