Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Compressing Export Dumps

Re: Compressing Export Dumps

From: <Rachel_Carmichael_at_Sonymusic.com>
Date: Thu, 16 May 2002 05:13:23 -0800
Message-ID: <F001.00462244.20020516051323@fatcity.com>

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).
Received on Thu May 16 2002 - 08:13:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US