01-07-2013
Quote:
Originally Posted by
qwertyu
[...]
Is there a way/ option in expdp where the dump file will be automatically zipped when its been created.
No, there is not way to use
Unix pipes for this. If you use
Oracle 11g AND you have the
Advanced Compression option (requires an extra license on top of
EE),
you could generate compressed dumps with
COMPRESSION=ALL.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I am trying to return the name of the resulting file from a .zip archive file using unix unzip command.
unzip c07212007.cef7081.zip
Archive: c07212007.cef7081.zip
SecureZIP for z/OS by PKWARE
inflating: CEP/CEM7080/PPVBILL/PASS/G0063V00
I used the following command to unzip in... (5 Replies)
Discussion started by: oracledev
5 Replies
3. AIX
I have to zip many pdf files and the size of zip file must not exceed 200 MB. When size is more than 200 MB then multiple zip files needs to be created.
How we can achieve this in UNIX?
I have tried ZIP utility but it takes a lot of time when we add individual pdfs by looping through a... (1 Reply)
Discussion started by: tom007
1 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I need to zip a .dat file with .zip extension. I tried using the "zip" command. But shell says. "ksh: zip: not found"
Currently I am using gunzip to zip and changing the extension ".gz" to ".zip" as follows.
mv $file `echo $file | sed 's/\(.*\.\)gz/\1zip/'`
But when I tried... (1 Reply)
Discussion started by: aeroticman
1 Replies
5. UNIX for Advanced & Expert Users
I've a zip file called Z00.zip and in that file there are 22 more zip files. Each zip file having .txt files nearly 10,000 files. I am trying to unzip all these .txt files in one command line to unzip each .zip file from Z00.zip file. Would like to know whether possible to unzip all sub-zip files... (1 Reply)
Discussion started by: nvkuriseti
1 Replies
6. Shell Programming and Scripting
i am using expdp in korn shell to export tables from oracle. What i dont know is how to capture any errors if my expdp fails.
I am looking for some options like Spool where i can write the error into a file and return the location of that file to my calling script in case of errors. Please help me... (2 Replies)
Discussion started by: qwertyu
2 Replies
7. Shell Programming and Scripting
Hi
I have a requirement in unix shell where I need to zip multiple files on server to one single .zip file. I dont see zip command in AIX and gzip command not doing completely what I want.
One I do .zip file, I should be able to unzip in my local Computer.
Here is example what I want... (9 Replies)
Discussion started by: RAMA PULI
9 Replies
8. UNIX and Linux Applications
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Discussion started by: clerck
2 Replies
9. UNIX for Beginners Questions & Answers
Hi all i am very new to shell scripting and need some help from you to learn
1)i have some log files that gets generated on daily basis example: i have abc_2017_01_30_1.log ,2017_01_30_2.log like wise so i want to zip this 4 logs which are created on same date into one zip folder.
2)Post zipping... (2 Replies)
Discussion started by: b.saipriyanka
2 Replies
10. Shell Programming and Scripting
Hi all i am very new to shell scripting and need some help from you to learn
1)i have some log files that gets generated on daily basis example: i have abc_2017_01_30_1.log ,2017_01_30_2.log like wise so i want to zip this 4 logs which are created on same date into one zip folder.
2)Post zipping... (1 Reply)
Discussion started by: b.saipriyanka
1 Replies
LEARN ABOUT CENTOS
advzip
AdvanceCOMP ZIP Compression Utility(1) General Commands Manual AdvanceCOMP ZIP Compression Utility(1)
NAME
advzip - AdvanceCOMP ZIP Compression Utility
SYNOPSIS
advzip [-a, --add] [-x, --extract] [-l, --list]
[-z, --recompress] [-t, --test] [-0, --shrink-store]
[-1, --shrink-fast] [-2, --shrink-normal] [-3, --shrink-extra]
[-4, --shrink-insane] [-N, --not-zip] [-p, --pedantic] [-q, --quiet]
[-h, --help] [-V, --version] ARCHIVES... [FILES...]
DESCRIPTION
The main purpose of this utility is to recompress and test the zip archives to get the smallest possible size.
For recompression the 7-Zip (www.7-zip.com) Deflate implementation is used. This implementation generally gives 5-10% more compression than
the zLib Deflate implementation.
For experimental purpose also the 7-Zip LZMA algorithm is available with the -N option. In this case, the generated zips WILL NOT BE USABLE
by any other program. To make them usable you need to recompress them without the -N option. Generally this algorithm gives 10-20% more
compression than the 7-Zip Deflate implementation.
OPTIONS
-a, --add ARCHIVE FILES...
Create the specified archive with the specified files. You must specify only one archive.
-x, --extract ARCHIVE
Extract all the files on the specified archive. You must specify only one archive.
-l, --list ARCHIVES...
List the content of the specified archives.
-z, --recompress ARCHIVES...
Recompress the specified archives. If the -1, -2, -3 options are specified, it's used the smallest file choice from: the previous
compressed data, the new compression and the uncompressed format. If the -0 option is specified the archive is always rewritten
without any compression.
-t, --test ARCHIVES...
Test the specified archives. The tests may be extended with the -p option.
-N, --not-zip
Use the LZMA algorithm when compressing. The generated zips will not be readable by any other application!
-p, --pedantic
Be pedantic on the zip tests. If this flag is enabled some more extensive tests on the zip integrity are done. These tests are gen-
erally not done by other zip utilities.
-0, --shrink-store
Disable the compression. The file is only stored and not compressed. This option is very useful to expand the archives of .png and
.mp3 files. These files are already compressed, trying to compress them another time is really a waste of time and resource.
-1, --shrink-fast
Set the compression level to "fast".
-2, --shrink-normal
Set the compression level to "normal". This is the default level of compression.
-3, --shrink-extra
Set the compression level to "extra".
-4, --shrink-insane
Set the compression level to "insane".
COPYRIGHT
This file is Copyright (C) 2002 Andrea Mazzoleni, Filipe Estima
SEE ALSO
advpng(1), advmng(1), advdef(1)
AdvanceCOMP ZIP Compression Utility(1)