RE: Compressing Export Dumps
Simon - I'll repeat (for the third time, I believe) that this sounds like an ideal use for database cloning. Much faster, and as a bonus you get to test your backups, which is always an excellent idea. More information can be found at http://asktom.oracle.com/pls/ask/f?p=4950:8:843675::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:575623107841,%7Bclone%7D Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 18, 2002 6:28 AM To: Multiple recipients of list ORACLE-L Hi Jared, Sorry about the delayed response. Trying to import into Training DB/Stadby DB/Development DB. A kind of backup plan also -Anyhting wrong with this? Thanks -Original Message- Sent: Thursday, May 16, 2002 8:29 PM To: Multiple recipients of list ORACLE-L Simon, I'm curious as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared "Simon Waibale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/16/2002 02:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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: Simon Waibale 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: DENNIS WILLIAMS 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).
RE: Compressing Export Dumps
Hi Jared, Sorry about the delayed response. Trying to import into Training DB/Stadby DB/Development DB. A kind of backup plan also -Anyhting wrong with this? Thanks -Original Message- Sent: Thursday, May 16, 2002 8:29 PM To: Multiple recipients of list ORACLE-L Simon, I'm curious as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared "Simon Waibale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/16/2002 02:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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: Simon Waibale 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).
Re: Compressing Export Dumps
way back (7.3 version) I wrote a set of scripts to export to a pipe, split and compress the split files.. It was based on the Metalink doc and I *think* copies of them are still out on the archives on www.lazydba.com but now, when you can split files via export, so the split is done by Oracle and supposedly fool-proof, why not do it that way? |+---> || | || | || lembark@wrkho| || rs.com | || | || 05/16/2002 | || 10:38 AM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Compressing Export Dumps| >| >> 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) Easier of you split the zipped result: mknod /tmp/dump p; gzip --fast < /tmp/dump | split -b $((1024*1024*1024)) date +"dump-%Y%m%d"; Gives a set of 1GB files as output. Simpler to manage since they all have the same size (whatever you set -b to) w/ a runt file at the end. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: 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).
RE: Compressing Export Dumps|
I was just about to post a message asking the same thing. Many of us have seen databases produce dumps which at first were much smaller than 2 GB, then we had to pipe them through the native compress utility on UNIX to keep them that way, then we used gzip which does a better job of compression, finally when this wasn't enough we combined gzip with split. For the above, assume the backup system cannot handle files over 2GB. But why export routinely in the first place. They are not a good recovery mechanism. Using an export almost always means loss of data. If a table is lost we can recover, that tablespace, the system tablespace, and the rollback tablespace, to a point-in-time just before the table was lost from our hot backups, and then export the "lost" table fom this "mini" database and import it into the one from which it was dropped. If an overzealous user ran some incorrect DML, we can run the undo statement from log miner. One can argue that if for some reason the physical backups are damaged, restoring from an export with some loss of data is better than no recovery at all. It also protects against errors in the physical backup script which may result in incomplete backups. Export can aid in identifying bad table blocks as it selects every row from every non "sys" table. However, as your database grows larger selecting every row becomes more and more expensive. Even if your exports are "inconsistent" they have an impact on rollback segments. No, they do not produce any undo, however they do expect that the schemas being exported stay the same. Schema changes while an export is underway can produce snapshot too old errors and stop the export. Although now schema changes usally, always? result in a failure to export just the table involved. The problem with setting "optimal" for rollback segments is very likely to be exposed by an export. I am curious about the number of people who have stopped using them as part of their daily backup strategy, and if you have. what are you doing to check for block corruption. Assume the database is 24 X 7. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Simon, I'm curious as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared "Simon Waibale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/16/2002 02:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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: MacGregor, Ian A. 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).
Re: Compressing Export Dumps
I do full export backups but they are only used for object restores, e.g. developer deletes all rows in table, etc. All it takes is a little time and disk space. Much easier to restore a table than do a point in time recovery. I find object restores more common than datafile, database recoveries, etc. esp. in development databases :) FWIW, Gene >>> [EMAIL PROTECTED] 05/16/02 01:28PM >>> Simon, I'm curious as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared "Simon Waibale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/16/2002 02:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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).
Re: Compressing Export Dumps / WinZip
It all depends which words you use -- sorry for the ambiguity... As Cary replied earlier, EXP just queries sys.seg$ (i.e. DBA_SEGMENTS) to find the bytes and uses that for the newly-calculated INITIAL. This can be seen in a SQL Trace initiated on the EXP's server process... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 10:48 AM Tim, I may be wrong but I thought that compress=y just adds up the total space allocation from SEG$ rather than calculating them from storage parameters. I know this is a trivial point but I'd appreciate the info if it sets about things differently. regards, Mike Hately -Original Message- Sent: 16 May 2002 17:14 To: Multiple recipients of list ORACLE-L The "compress=y" option doesn't have any effect on how data is stored in the export dump file, only some of the metadata. It directs the EXP program to recalculate the DDL for all of the tables and indexes (instead of just using the settings in the data dictionary) so that all space previously allocated for the object is now contained in a single extent. In other words, if a table being exported had a STORAGE clause like: storage (initial 1M next 1M pctincrease 0) and it currently had 500 extents allocated to it, then the EXP program would store the DDL for the table in the export dump file with a new STORAGE clause: storage (initial 500M next 1M pctincrease 0) There are several flaws with this mechanism: * the table may be completely empty of rows, but 500M will still be allocated for its initial extent. The COMPRESS=Y option doesn't consider the possibility that rows may have been deleted... * the idea that a single extent is better than many extents is complete nonsense (I wrote a paper in spring 2001 on this, posted at www.EvDBT.com/library.htm, entitled "Myths About Extents And Performance")... * the idea that a single large extent is better than many extents actually increases the probability and problems associated with "tablespace free-space fragmentation" instead of reducing it. Think about it: everything may look "good" immediately after import, but what happens after a few weeks or months? Although COMPRESS=Y is the default, I strongly advise that you use COMPRESS=N to disable this functionality, in most cases. Just my $0.02... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:33 AM Patrice - That would be correct. If you run export interactively, the prompt that is provided is "compress extents (y/n)". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: DENNIS WILLIAMS 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Re: Compressing Export Dumps
Simon, I'm curious as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared "Simon Waibale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/16/2002 02:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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).
RE: Compressing Export Dumps / WinZip
Using "compress=y" means only that the value of the "initial" storage parameter written to the "create" DDL statement in the .dmp file gets set to the value of "select sum(bytes) from dba_extents where owner=:v1 and segment_name=:v2". "compress=y" is a wretched, awful thing for a number of reasons, not the least of which is that it causes imports to fail if you have a segment that's bigger than your OS-restricted maximum file size. The parameter is poorly named because it causes no space savings whatsoever. To the contrary, using "compress=y" preserves whatever wasted space has accumulated during the segment's history. Because of the parameter's misleading name, many people attribute temporary performance gains after using exp and then imp to the "compress=y" setting, but you'll actually get identical performance gains by using "compress=n". DBAs should almost always use "compress=n" instead of allowing the default "compress=y" to change their extent sizes. Better yet, DBAs should use uniform extent sizes with their locally managed tablespaces and avoid the "compress=y|n" problem entirely. Cary Millsap Hotsos Enterprises, Ltd. [EMAIL PROTECTED] http://www.hotsos.com -Original Message- Shirley Sent: Thursday, May 16, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Doesn't it mean that all rows are compressed into 1 extent? -Original Message- Sent: Thursday, May 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject:RE: Compressing Export Dumps / WinZip I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Taylor, Shirley 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: Cary Millsap 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).
RE: Compressing Export Dumps / WinZip
Tim, I may be wrong but I thought that compress=y just adds up the total space allocation from SEG$ rather than calculating them from storage parameters. I know this is a trivial point but I'd appreciate the info if it sets about things differently. regards, Mike Hately -Original Message- Sent: 16 May 2002 17:14 To: Multiple recipients of list ORACLE-L The "compress=y" option doesn't have any effect on how data is stored in the export dump file, only some of the metadata. It directs the EXP program to recalculate the DDL for all of the tables and indexes (instead of just using the settings in the data dictionary) so that all space previously allocated for the object is now contained in a single extent. In other words, if a table being exported had a STORAGE clause like: storage (initial 1M next 1M pctincrease 0) and it currently had 500 extents allocated to it, then the EXP program would store the DDL for the table in the export dump file with a new STORAGE clause: storage (initial 500M next 1M pctincrease 0) There are several flaws with this mechanism: * the table may be completely empty of rows, but 500M will still be allocated for its initial extent. The COMPRESS=Y option doesn't consider the possibility that rows may have been deleted... * the idea that a single extent is better than many extents is complete nonsense (I wrote a paper in spring 2001 on this, posted at www.EvDBT.com/library.htm, entitled "Myths About Extents And Performance")... * the idea that a single large extent is better than many extents actually increases the probability and problems associated with "tablespace free-space fragmentation" instead of reducing it. Think about it: everything may look "good" immediately after import, but what happens after a few weeks or months? Although COMPRESS=Y is the default, I strongly advise that you use COMPRESS=N to disable this functionality, in most cases. Just my $0.02... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:33 AM Patrice - That would be correct. If you run export interactively, the prompt that is provided is "compress extents (y/n)". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: DENNIS WILLIAMS 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: Tim Gorman 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). _
RE: Compressing Export Dumps / WinZip
yes. I just wanted to verify though. One DBA answered that I must be joking... : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 12:43 PM To: Multiple recipients of list ORACLE-L Doesn't it mean that all rows are compressed into 1 extent? -Original Message- Sent: Thursday, May 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject:RE: Compressing Export Dumps / WinZip I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Taylor, Shirley 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: Boivin, Patrice J 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).
RE: Compressing Export Dumps/WinZip
Large chunks of export files are entirely readable. You can open them in vi and read it because character data is stored as plain text, hence the potentially good compression rates. I agree I wouldn't like to have to decipher a lot of numeric fields. Regards, Mike Hately BTW Robert (Freeman), LMAO! -Original Message- Sent: 16 May 2002 17:14 To: Multiple recipients of list ORACLE-L Patrice, Yes, that's right. On our Tru64 Unix platforms, I was amazed to find that even though I knew the export dump files to be binary files and (what I assumed to be) not only Oracle-extent-compressed, but binary-data-compressed...that in using gzip/gunzip we were achieving compression percentages of up to 50% and even more. Jim Damiano -Original Message- Sent: Thursday, May 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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).
RE: Compressing Export Dumps / WinZip
Yup... -Original Message- Sent: Thursday, May 16, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Doesn't it mean that all rows are compressed into 1 extent? -Original Message- Sent: Thursday, May 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compressing Export Dumps / WinZip I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Taylor, Shirley 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: Freeman, Robert 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).
RE: Compressing Export Dumps / WinZip
Ok is this a joke?? If not, I think someone needs to crack the Oracle Utilities manual... RF -Original Message- Sent: Thursday, May 16, 2002 11:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Freeman, Robert 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).
Re: Compressing Export Dumps / WinZip
The "compress=y" option doesn't have any effect on how data is stored in the export dump file, only some of the metadata. It directs the EXP program to recalculate the DDL for all of the tables and indexes (instead of just using the settings in the data dictionary) so that all space previously allocated for the object is now contained in a single extent. In other words, if a table being exported had a STORAGE clause like: storage (initial 1M next 1M pctincrease 0) and it currently had 500 extents allocated to it, then the EXP program would store the DDL for the table in the export dump file with a new STORAGE clause: storage (initial 500M next 1M pctincrease 0) There are several flaws with this mechanism: * the table may be completely empty of rows, but 500M will still be allocated for its initial extent. The COMPRESS=Y option doesn't consider the possibility that rows may have been deleted... * the idea that a single extent is better than many extents is complete nonsense (I wrote a paper in spring 2001 on this, posted at www.EvDBT.com/library.htm, entitled "Myths About Extents And Performance")... * the idea that a single large extent is better than many extents actually increases the probability and problems associated with "tablespace free-space fragmentation" instead of reducing it. Think about it: everything may look "good" immediately after import, but what happens after a few weeks or months? Although COMPRESS=Y is the default, I strongly advise that you use COMPRESS=N to disable this functionality, in most cases. Just my $0.02... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:33 AM Patrice - That would be correct. If you run export interactively, the prompt that is provided is "compress extents (y/n)". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: DENNIS WILLIAMS 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: Tim Gorman 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).
RE: Compressing Export Dumps / WinZip
That's right. "compress=y" is the export default; it causes all extents of an object to be combined into one. --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > I don't know whether this is a tangent, but I notice that on the > windows > platform, "compressed" exports can still get 85% compression when > zipping > them with WinZip. > > Obviously Oracle "compressed=y" doesn't mean "compress the export > file", it > just means that it places all the segments contiguously in the export > file. > > Right? > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > 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). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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).
RE: Compressing Export Dumps / WinZip
Doesn't it mean that all rows are compressed into 1 extent? -Original Message- Sent: Thursday, May 16, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compressing Export Dumps / WinZip I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Taylor, Shirley 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).
RE: Compressing Export Dumps / WinZip
there is a BIG difference between the "COMPRESS=Y" parameter on an export and compressing a file! the parameter changes the "create table" statement placed in the export file so that the initial extent is large enough to hold the entire table. It does NOT affect the size of the export dump file in the least. Compressing a file at the OS level removes "waste" space and (usually) significantly reduces the file size |+-> || | || | || [EMAIL PROTECTED]| || -mpo.gc.ca | || | || 05/16/2002 | || 11:08 AM | || Please respond | || to ORACLE-L| || | |+-> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Compressing Export Dumps / | | WinZip | >| I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: 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).
RE: Compressing Export Dumps / WinZip
Patrice - That would be correct. If you run export interactively, the prompt that is provided is "compress extents (y/n)". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 16, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: DENNIS WILLIAMS 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).
RE: Compressing Export Dumps / WinZip
I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" doesn't mean "compress the export file", it just means that it places all the segments contiguously in the export file. Right? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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).
Re: Compressing Export Dumps
>> 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) Easier of you split the zipped result: mknod /tmp/dump p; gzip --fast < /tmp/dump | split -b $((1024*1024*1024)) date +"dump-%Y%m%d"; Gives a set of 1GB files as output. Simpler to manage since they all have the same size (whatever you set -b to) w/ a runt file at the end. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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).
Re: Compressing Export Dumps
[EMAIL PROTECTED] wrote: > > 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. i'm doing that with an 8.1.5 instance right now. works seamlessly. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Software is mind work. Having the right frame of mind is essential. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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).
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 >>> [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).
RE: Compressing Export Dumps
Sergey, Thanks for the mkfifo idea. I've also come across "mknod myfifo p;compess < myinfo > myinfo.Z" I'm looking at the two options, yet to ascertain whether second method works with gzip. Do you know of any known troubles (Block/File corruption) with first method ? Do I have to "rm yourinfo" or I can re-use the piping file ( as in ascript) ? Thanks once again, Simon -Original Message- Sent: Thursday, May 16, 2002 2:48 PM To: Multiple recipients of list ORACLE-L Hello Simon, You can make it like this: mkfifo yourfifo gzip outfile.dmp.gz & exp ... file=yourfifo rm yourfifo Thursday, May 16, 2002, 4:38:40 PM, you wrote: SW> Hi all, SW> My export dumps are too big (80 GB) for my filesystem and I'm looking for a SW> way SW> to compress them on the fly -ie without taking *.dmp to disk first but SW> straight *.dmp.gz SW> Anybody with an idea on how to archive this ? SW> Thanking you, SW> --- SW> CSW -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov 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: Simon Waibale 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).
Re: Compressing Export Dumps
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).
Re: Compressing Export Dumps
Hello Simon, You can make it like this: mkfifo yourfifo gzip outfile.dmp.gz & exp ... file=yourfifo rm yourfifo Thursday, May 16, 2002, 4:38:40 PM, you wrote: SW> Hi all, SW> My export dumps are too big (80 GB) for my filesystem and I'm looking for a SW> way SW> to compress them on the fly -ie without taking *.dmp to disk first but SW> straight *.dmp.gz SW> Anybody with an idea on how to archive this ? SW> Thanking you, SW> --- SW> CSW -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov 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).
RE: Compressing Export Dumps
BDY.RTF Description: RTF file
