Unix/Linux Go Back    


Shell Programming and Scripting BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

Zip dump file using expdp:

Shell Programming and Scripting


Closed    
 
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 offline Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 7 December 2016, 12:24 PM EST
Location: Zürich
Posts: 8,598
Thanks: 343
Thanked 1,093 Times in 949 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: 11 December 2016, 1:55 AM EST
Posts: 997
Thanks: 26
Thanked 264 Times in 241 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 offline Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 7 December 2016, 12:24 PM EST
Location: Zürich
Posts: 8,598
Thanks: 343
Thanked 1,093 Times in 949 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: 11 December 2016, 1:55 AM EST
Posts: 997
Thanks: 26
Thanked 264 Times in 241 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 Advisor  
Forum Adviser
 
Join Date: Jan 2007
Last Activity: 16 December 2015, 5:59 AM EST
Location: Варна, България / Milano, Italia
Posts: 5,690
Thanks: 184
Thanked 629 Times in 586 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

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 04:35 AM
Zip a file with .zip extension. aeroticman UNIX for Dummies Questions & Answers 1 08-04-2010 02:54 PM
ZIP multiple files and also specify size of zip file tom007 AIX 1 03-16-2010 03:29 AM
unzip .zip file and list the files included in the .zip archive oracledev UNIX for Dummies Questions & Answers 5 04-08-2008 05:49 PM



All times are GMT -4. The time now is 05:51 AM.