Re: dynamically compressing export

Hi Winnie, here's the deal.

So I'm told, when the export/compress runs, it takes up ~4GB of memory. If the host starts swapping, the resulting compressed file is then very likely corrupted. I did not test this myself. I am going on what I was told. And quite honestly I now don't have time to test it myself because I'm fighting with a <d$%@!> listener. I just told management that there will be no exports of this databse any more and that our only recovery is with rman.

Oh it's been an awful day. Can I move to Florida yet... today it sounds like a good idea.

Thanks
Lisa

Winnie_Liu_at_infonet.com on 05/23/2000 04:57:34 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: Re: dynamically compressing export

Lisa,

Can you tell us more how's the "compression is corrupting the export file"?

I've been using the compress while export all this time without any problem.

Winnie

Lisa_Koivu_at_gelco.com on 05/23/2000 09:00:12 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Hi Bill, thanks for your response.

Yes we've got the same type of thing going on, dynamic compression. However the compression is corrupting the export file. I need to export it first, complete the export, and then compress it. What a pain in the a$$. I am
going to have to split up my export into about 10-15 pieces, I think. Talk about
messy.

bill thater <thaterw_at_telergy.net> on 05/23/2000 09:36:07 AM

To: Lisa Koivu/GELCO_at_GELCO
cc: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

On May 23, Lisa_Koivu_at_gelco.com scribbled on the wall in glitter crayon:

->Hello everyone -
->
->Anyone run into a problem with dynamically compressing an export with a
pipe?
I
->am told that importing a file after this type of export/compression is
not
100%.
->Sometimes imp thinks the file is corrupt.
->
->I now have to change my nice dynamic export script to be piecemeal and
->not-so-dynamic to keep file sizes under 2G, and compress after export....
->iiiiiicccccccccckkkkkk.
->
->thanks
->Lisa
->Better known as LIAS
->
->
->
->

head on over to <http://www.lazydba.com> and get rachel charmichael's scripts to do just that. works like a charm, right ruth?;-)

--
Bill Thater             Certified ORACLE DBA
Telergy, Inc.            thaterw_at_telergy.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Do or not do.  There is no try.  -- Yoda
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ethics only exists in the eyes of the beholder.









--
Author:
  INET: Lisa_Koivu_at_gelco.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).






--
Author:
  INET: Winnie_Liu_at_infonet.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