| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: using pipe to export oracle on windows platform
Or one could use dbms_pipe and push/pull the data.
-----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-lReceived on Thu Oct 21 2004 - 09:44:10 CDT
 |
 |