Oracle-L: RE: Using Named Pipes on Windows

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 16 May 2003 11:11:57 -0800
Message-ID: <F001.0059B2F1.20030516111157@fatcity.com>

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
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------