Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using Named Pipes on Windows

RE: Using Named Pipes on Windows

From: <Jared.Still_at_radisys.com>
Date: Fri, 16 May 2003 11:57:25 -0800
Message-ID: <F001.0059B4FE.20030516115725@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US