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: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Thu, 21 Oct 2004 08:49:28 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B438F80@fiji.arraybp.com>


Or one could use dbms_pipe and push/pull the data.



Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Charlotte Hammond Sent: Thursday, October 21, 2004 8: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

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

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

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender  of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

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

Original text of this message

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