Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is there an export and zip utility in Window NT?
Leigh Gold wrote:
>
> In unix, you can do an export and compress the dmp file at the same time.
> This really save a lot of disk space.
>
> Is there similar utility in Window NT?
>
> Thanks,
>
> Leigh
Hi Leigh,
I believe that it can be accomplished in one pass if you use pipes.
If you have enough space on disk, dump it to disk and compress it
afterward.
PowerArchiver has command line support for compression.
WinZip8 has now has command line suport, but I haven't tried it yet.
Blat is a free utility for mailing text files.
hth,
Paul
example code:
rem exp_dev_job.bat
set oracle_sid=DEV
exp parfile=d:\Oracle\admin\dev\exp\export.par
pacomp -a -c1 e:\ZipFiles\dev\EXP\dev_dat.zip
D:\Oracle\Admin\dev\exp\dev_dat.*
blat d:\Oracle\admin\ems\exp\expdat.log log_files_at_foo.com
exit
Received on Sat Aug 18 2001 - 00:38:14 CDT