Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dynamically compressing export
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFC585.01231CB0
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
Here's something that will cause big problems:
multiple scripts exporting/compressing multiple db's through _the same pipe at the same time_ !!
A, uh... friend of mine... had this happen to him once. No errors of any kind until I - oops I mean he - tried to import. Very ugly!
Humbly,
Jerry
-----Original Message-----
From: VIVEK_SHARMA [mailto:vivek_sharma_at_inf.com]
Sent: Wednesday, May 24, 2000 4:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: dynamically compressing export
Have Successfully Exported & imported from a Compressed Export Dump (using a
pipe)
on the SAME OS (SunOS)
> -----Original Message-----
> From: Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
> Sent: Tuesday, May 23, 2000 8:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: dynamically compressing export
>
> 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
>
>
>
> --
> 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: VIVEK_SHARMA INET: vivek_sharma_at_inf.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). ------_=_NextPart_001_01BFC585.01231CB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: dynamically compressing export</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Hi,</FONT> </P> <P><FONT SIZE=3D2>Here's something that will cause big problems:</FONT> </P> <P><FONT SIZE=3D2>multiple scripts exporting/compressing multiple db's = through _the same pipe at the same time_ !! </FONT> </P> <P><FONT SIZE=3D2>A, uh... friend of mine... had this happen to him = once. No errors of any kind until I - oops I mean he - tried to import. = Very ugly!</FONT></P> <BR> <P><FONT SIZE=3D2>Humbly,</FONT> </P> <P><FONT SIZE=3D2>Jerry </FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: VIVEK_SHARMA [<A = HREF=3D"mailto:vivek_sharma_at_inf.com">mailto:vivek_sharma_at_inf.com</A>]</F= ONT> <BR><FONT SIZE=3D2>Sent: Wednesday, May 24, 2000 4:53 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: dynamically compressing export</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Have Successfully Exported & imported from a = Compressed Export Dump (using a</FONT> <BR><FONT SIZE=3D2>pipe)</FONT> <BR><FONT SIZE=3D2>on the SAME OS (SunOS)</FONT> </P> <P><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Lisa_Koivu_at_gelco.com = [SMTP:Lisa_Koivu_at_gelco.com]</FONT> <BR><FONT SIZE=3D2>> Sent: Tuesday, May 23, 2000 8:38 PM</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list = ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: = dynamically compressing export</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Hello everyone -</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Anyone run into a problem with dynamically = compressing an export with a</FONT> <BR><FONT SIZE=3D2>> pipe? I</FONT> <BR><FONT SIZE=3D2>> am told that importing a file after this type = of export/compression is not</FONT> <BR><FONT SIZE=3D2>> 100%.</FONT> <BR><FONT SIZE=3D2>> Sometimes imp thinks the file is = corrupt.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> I now have to change my nice dynamic export = script to be piecemeal and</FONT> <BR><FONT SIZE=3D2>> not-so-dynamic to keep file sizes under 2G, and = compress after export....</FONT> <BR><FONT SIZE=3D2>> iiiiiicccccccccckkkkkk.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> thanks</FONT> <BR><FONT SIZE=3D2>> Lisa</FONT> <BR><FONT SIZE=3D2>> Better known as LIAS</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: </FONT> <BR><FONT SIZE=3D2>> INET: Lisa_Koivu_at_gelco.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: VIVEK_SHARMA</FONT> <BR><FONT SIZE=3D2> INET: vivek_sharma_at_inf.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Wed May 24 2000 - 08:36:18 CDT
![]() |
![]() |