RE: Exp with Compress, dmp corrupted !

From: Leonardo Fernandez <lfernand_at_cmsenergy.com>
Date: Tue, 9 Jan 2001 12:03:41 -0500
Message-Id: <10736.126154@fatcity.com>

Thanks, Lisa

Yes I=B4m limited to 2GB file size ... It is my preoccupation

Any annotation ?
Regards,

"Koivu, Lisa" <lkoivu_at_qode.com> on 09/01/2001 10:28:56 AM

To: "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com>,

"'lfernand_at_cmsenergy.com'" <lfernand_at_cmsenergy.com> cc:
Subject: RE: Exp with Compress, dmp corrupted !

I've seen this several times.=A0 If your host was swapping during the e= xport,
it very likely corrupted your export file.

Can you export it without compress?=A0 Are you limited to 2GB file size= ?
Here on hp/ux 11 I am not so I create ~15GB exp file every night and compress it after the exp completes.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL=A0 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or posit=
ion
of Qode.com and cannot be attributed to or made binding upon Qode.com."=

-----Original Message-----
From: Leonardo Fernandez [mailto:lfernand_at_cmsenergy.com] Sent: Tuesday, January 09, 2001 7:36 AM
To: Multiple recipients of list ORACLE-L Subject: Exp with Compress, dmp corrupted !

Last week it generates an export with:
mknod /tmp/exp_dbacom p
compress < /tmp/exp_dbacom > /conversion/IC_TABLAS.dmp.Z & expst userid=3Duser/password file=3D/tmp/exp_dbacom buffer=3D20000000 parfile=3Dtab1

and when it tries to import with:
mknod /tmp/imp_dbacom p
uncompress <=A0 /conversion/IC_TABLAS.dmp.Z > /tmp/imp_dbacom & impst file=3D/tmp/imp_dbacom parfile=3Dtab2

I received the following error:

IMP-00037: Character set marker unknown
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

I have always "cloned" databases, both are same (init.ora, etc)

Metalink tells me that the file this corrupt one ...

Any idea or suggestion in this respect

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leonardo Fernandez
=A0 INET: lfernand_at_cmsenergy.com

Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) 538-=
5051
San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- 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).=A0 You may

Received on Tue Jan 09 2001 - 11:03:41 CST