Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: compress while exporting file on Window using winzip
On Dec 8, 12:53 am, "Anthony" <akkha1..._at_gmail.com> wrote:
> We are using winzip command line interface to compress oracle export
> file on windows platform in our script. Is it possible to compress the
> file as it is created? That would save a lot of disk space. I know we
> can do it on UNIX (been using it since day 1). How about Windows?
>
> Thanks a lot in advance
You don't mention your version.
If you have anything current (10g), IIRC expdp in 10g is capable of
compressing the export automagically.
Other than that, your question boils down to:
it is possible to export to a pipe on Windows (Windows does support
pipes), and can Winzip read from a pipe. That is not an Oracle
question.
But probably you are better of buying a bigger disk. It would be
cheaper than writing scripts anyway.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Dec 08 2006 - 03:38:03 CST