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 >>> [EMAIL PROTECTED] 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 |--------+-----------------------> | | | | | | | | [EMAIL PROTECTED]| | | o.ug | | | | | | 05/16/2002 | | | 05:38 AM | | | Please | | | respond to | | | ORACLE-L | | | | |--------+-----------------------> >----------------------------------------------------| | | | To: [EMAIL PROTECTED] | | 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
