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: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 21 Oct 2004 10:57:25 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501B9E0B8@25exch1.vicorpower.vicr.com>


Yesterday at the Northeast Oracle Users Group meeting there was a presentation by the Oracle development folks in Nashua NH about 10g's Data Pump (the replacement for export/import). Those of us using pipes to facilitate these kinds of things are going to have to change gears. Data Pump does not support pipes. Course it has some other really nice features that should make them unnecessary.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Charlotte Hammond [mailto:charlottejanehammond_at_yahoo.com]=20 Sent: Thursday, October 21, 2004 10:47 AM To: ORACLE-L
Subject: Re: using pipe to export oracle on windows platform

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.
=20

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.
=20

- Charlotte
=20
=20

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?  =20
=20

--
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?
 =20

=20
-- Regards Zhu Chao www.cnoug.org -- =09 --------------------------------- Do you Yahoo!? Yahoo! Mail - You care about security. So do we. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 21 2004 - 10:03:05 CDT

Original text of this message

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