Oracle-L: RE: Using Named Pipes on Windows

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 16 May 2003 11:51:55 -0800
Message-ID: <F001.0059B4CA.20030516115155@fatcity.com>

Probably a windows limitation ...

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Friday, May 16, 2003 3:12 PM
To: Multiple recipients of list ORACLE-L

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-----
<mailto:Jared.Still_at_radisys.com> ]

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
<http://www.orafaq.net>
-- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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
<http://www.orafaq.net>
-- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.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).

text/plain attachment: ESPN_Disclaimer.txt

Received on Fri May 16 2003 - 14:51:55 CDT