RE: Exp with Compress, dmp corrupted !

Hi there,

Make sure nothing else is using the same pipe at the same time. A, uhhh, friend of mine did this once (2 scripts running at the same time, through the same pipe, no error messages until you try to import) and I -- uhh, I mean he - received the same error message.

:)

Just a thought...

• Jerry

-----Original Message-----
From: Jim Conboy [mailto:Jim.Conboy_at_trw.com] Sent: Tuesday, January 09, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp with Compress, dmp corrupted !

I had a similar sounding problem once with compressed export. Never received an error message, all logs looked fine, etc. But just by looking at file sizes (after the fact, of course) I could see the export was much smaller than it should have been. When I re-exported everything looked the same, except the dump file was much larger and had the added benefit of actually working. Now I keep a file size history and double-check just to make sure. Never happened again but you never know...

Jim

>
> 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_at_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_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us 

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Conboy
  INET: Jim.Conboy_at_trw.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