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 pipe to export oracle on windows platform

Re: using pipe to export oracle on windows platform

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Thu, 21 Oct 2004 07:47:14 -0700 (PDT)
Message-ID: <20041021144714.99499.qmail@web20709.mail.yahoo.com>


If you find a good answer please let me know! I believe Windows does have a pipe mechanism but it isn't exposed to the OS, so mknod is unimplemented in cygwin.  

The obvious approach is to just export and then compress in two steps. When short of disk space we have done this via a crossover cable to another Windows box. Another thing to try might be to use the FILESIZE switch in exp, and then gzip each individual "sub-file" in turn (from another session) as soon as exp stops writing to it. You can then write a nice script on Solaris to untaggle this.  

Hi friends:

   We have to migrate a database on windows 2000 to Solaris, and to another location. So we want to reduce the size of the dump file via gzip.

   As windows does not support pipe like we do in unix: mknod exp.pipe p; gzip <exp.pipe >dmp.gz & and run exp. I tried cygwin. But seems gzip simply do not do anything there. Anyone tried using pipe on windows/cygwin? Or is there similar workaround?     

--

Regards
Zhu Chao
www.cnoug.org
--Hi friends:

   We have to migrate a database on windows 2000 to Solaris, and to another location. So we want to reduce the size of the dump file via gzip.

   As windows does not support pipe like we do in unix: mknod exp.pipe p; gzip <exp.pipe >dmp.gz & and run exp. I tried cygwin. But seems gzip simply do not do anything there. Anyone tried using pipe on windows/cygwin? Or is there similar workaround?     

--

Regards
Zhu Chao
www.cnoug.org
--
                



Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 21 2004 - 09:42:43 CDT

Original text of this message

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