Unix/Linux Go Back    


Shell Programming and Scripting Unix shell scripting - KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and shell scripts and shell scripting languages here.

Zip dump file using expdp:

Shell Programming and Scripting


Closed Linux or Unix Question    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 01-04-2013
qwertyu qwertyu is offline
Registered User
 
Join Date: Nov 2012
Last Activity: 21 January 2013, 5:12 AM EST
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
Zip dump file using expdp:

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.
Sponsored Links
    #2  
Old Unix and Linux 01-04-2013
Scott's Unix or Linux Image
Scott Scott is online now Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 23 May 2015, 9:23 AM EDT
Location: Zürich
Posts: 8,552
Thanks: 337
Thanked 1,076 Times in 935 Posts
I don't know expdp, but if it can write to standard output instead of a regular file, this should work:

Code:
expdp ... | gzip -9c > yourexport.dmp.gz

But check first the expdp options. It might support compression natively.
Sponsored Links
    #3  
Old Unix and Linux 01-04-2013
Peasant's Unix or Linux Image
Peasant Peasant is offline
Registered User
 
Join Date: Mar 2011
Last Activity: 23 May 2015, 12:47 AM EDT
Posts: 761
Thanks: 19
Thanked 174 Times in 169 Posts
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.
    #4  
Old Unix and Linux 01-07-2013
qwertyu qwertyu is offline
Registered User
 
Join Date: Nov 2012
Last Activity: 21 January 2013, 5:12 AM EST
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
No the above dont seem to work.. Please suggest something else
Sponsored Links
    #5  
Old Unix and Linux 01-07-2013
Scott's Unix or Linux Image
Scott Scott is online now Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 23 May 2015, 9:23 AM EDT
Location: Zürich
Posts: 8,552
Thanks: 337
Thanked 1,076 Times in 935 Posts
You'll have to be a bit more specific about what "don't seem to work" means.
Sponsored Links
    #6  
Old Unix and Linux 01-07-2013
Peasant's Unix or Linux Image
Peasant Peasant is offline
Registered User
 
Join Date: Mar 2011
Last Activity: 23 May 2015, 12:47 AM EDT
Posts: 761
Thanks: 19
Thanked 174 Times in 169 Posts
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.
Sponsored Links
    #7  
Old Unix and Linux 01-07-2013
radoulov's Unix or Linux Image
radoulov radoulov is offline Forum Staff  
Moderator
 
Join Date: Jan 2007
Last Activity: 23 April 2015, 3:05 PM EDT
Location: Варна, България / Milano, Italia
Posts: 5,690
Thanks: 184
Thanked 624 Times in 582 Posts
Quote:
Originally Posted by qwertyu View Post
[...]
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.
Sponsored Links
Closed Linux or Unix Question

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Expdp error logging: qwertyu Shell Programming and Scripting 2 12-05-2012 03:35 AM
Zip a file with .zip extension. aeroticman UNIX for Dummies Questions & Answers 1 08-04-2010 01:54 PM
ZIP multiple files and also specify size of zip file tom007 AIX 1 03-16-2010 02:29 AM
How to unzip a zip file into a folder with the zip file's name? basis Shell Programming and Scripting 5 06-05-2008 07:10 AM
unzip .zip file and list the files included in the .zip archive oracledev UNIX for Dummies Questions & Answers 5 04-08-2008 04:49 PM



All times are GMT -4. The time now is 09:24 AM.