Message-Id: <10736.126146@fatcity.com> From: "Koivu, Lisa" Date: Tue, 9 Jan 2001 10:28:56 -0500 Subject: RE: Exp with Compress, dmp corrupted ! 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_01C07A50.E467D51A Content-Type: text/plain I've seen this several times. If your host was swapping during the export, it very likely corrupted your export file. Can you export it without compress? 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 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 position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----Original Message----- From: Leonardo Fernandez [mailto:lfernand@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=user/password file=/tmp/exp_dbacom buffer=20000000 parfile=tab1 and when it tries to import with: mknod /tmp/imp_dbacom p uncompress < /conversion/IC_TABLAS.dmp.Z > /tmp/imp_dbacom & impst file=/tmp/imp_dbacom parfile=tab2 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 INET: lfernand@cmsenergy.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@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_01C07A50.E467D51A Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Exp with Compress, dmp corrupted !

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

Can you export it without compress?  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  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 position of Qode.com and cannot be attributed to = or made binding upon Qode.com."


-----Original Message-----
From: Leonardo Fernandez [mailto:lfernand@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 <  /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
  INET: lfernand@cmsenergy.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@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