|
|||||||
| Forums | Search Forums | Register | Forum Rules | Man Pages | Albums | FAQ | Members | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
01-04-2013
|
|||
|
|||
|
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
01-04-2013
|
||||
|
||||
|
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
01-04-2013
|
||||
|
||||
|
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
01-07-2013
|
|||
|
|||
|
No the above dont seem to work.. Please suggest something else
|
| Sponsored Links | |
|
|
#5
01-07-2013
|
||||
|
||||
|
You'll have to be a bit more specific about what "don't seem to work" means.
|
| Sponsored Links | |
|
|
#6
01-07-2013
|
||||
|
||||
|
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
01-07-2013
|
||||
|
||||
|
Quote:
you could generate compressed dumps with COMPRESSION=ALL. |
| Sponsored Links | ||
|
|
| Thread Tools | Search this Thread |
| 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 |
|
|
Linear Mode
