Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Compressing Export Dumps
Yes, 8.1.7 exp has 2 new parameters:
filesize=53687058420 # 50gb file=file1.dmp,file2.dmp # 2 files
It helps when exporting a 1tb db. Using direct=y, gets it done in 4hours.
FWIW, Gene
>>> Rachel_Carmichael_at_Sonymusic.com 05/16/02 09:13AM >>>
If you are on Unix, you can pipe the export into a "split" command and break the file into multiples and compress on the fly. There's a note on metalink about it (note 30528.1)
Also, I *think* in 8.1.7 you can specify the size and names of the export files, so that Oracle will automatically break the large file into several smaller ones.
Check the Utilities manual
|--------+----------------------->
| | |
| | |
| | waibals_at_mtn.c|
| | o.ug |
| | |
| | 05/16/2002 |
| | 05:38 AM |
| | Please |
| | respond to |
| | ORACLE-L |
| | |
|--------+-----------------------> >----------------------------------------------------| | | | To: ORACLE-L_at_fatcity.com | | cc: (bcc: Rachel Carmichael) | | Subject: Compressing Export Dumps | >----------------------------------------------------|
Hi all,
My export dumps are too big (80 GB) for my filesystem and I'm looking for a
way
to compress them on the fly -ie without taking *.dmp to disk first but
straight *.dmp.gz
Anybody with an idea on how to archive this ?
Thanking you,
--- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Rachel_Carmichael_at_Sonymusic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais_at_co.palm-beach.fl.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 16 2002 - 09:08:22 CDT
![]() |
![]() |