Hi All,
i am using expdp to create a dump file of contents from an oracle table. I want this dump file to be zipped. Is there a way/ option in expdp where the dump file will be automatically zipped when its been created. If not please suggest other methods.
I don't know expdp, but if it can write to standard output instead of a regular file, this should work:
expdp ... | gzip -9c > yourexport.dmp.gz
But check first the expdp options. It might support compression natively.
Have you search the internet :
Import Export FAQ - Oracle FAQ
You can use named pipes with exp/imp on any oracle release, in manner explained in the article.
Regards
Peasant.
No the above dont seem to work.. Please suggest something else
You'll have to be a bit more specific about what "don't seem to work" means.
I will quote my favorite irc bot :
Doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money ? Is it on IRC all the time? Please be specific! Examples of what doesn't work tend to help too.
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.
Go to this site very useful............
How to compress oracle export � knowledge article for the new oracle dba | ITcareershift.com Blog
Sure, that site explains how to compress Oracle exports on the fly using the legacy exp utility.
The OP is asking for data pump (expdp) ...