Zip dump file using expdp: | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Zip dump file using expdp:

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 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 01-04-2013
Scott's Avatar
Scott Scott is online now Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 31 October 2014, 10:30 AM EDT
Location: Zürich
Posts: 8,484
Thanks: 332
Thanked 1,047 Times in 914 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 01-04-2013
Peasant's Avatar
Peasant Peasant is online now
Registered User
 
Join Date: Mar 2011
Last Activity: 31 October 2014, 10:43 AM EDT
Posts: 668
Thanks: 18
Thanked 150 Times in 146 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 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 01-07-2013
Scott's Avatar
Scott Scott is online now Forum Staff  
Administrator
 
Join Date: Jun 2009
Last Activity: 31 October 2014, 10:30 AM EDT
Location: Zürich
Posts: 8,484
Thanks: 332
Thanked 1,047 Times in 914 Posts
You'll have to be a bit more specific about what "don't seem to work" means.
Sponsored Links
    #6  
Old 01-07-2013
Peasant's Avatar
Peasant Peasant is online now
Registered User
 
Join Date: Mar 2011
Last Activity: 31 October 2014, 10:43 AM EDT
Posts: 668
Thanks: 18
Thanked 150 Times in 146 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 01-07-2013
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
Moderator
 
Join Date: Jan 2007
Last Activity: 29 October 2014, 9:43 AM EDT
Location: Варна, България / Milano, Italia
Posts: 5,675
Thanks: 184
Thanked 620 Times in 578 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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 10:56 AM.