Re: import from corrupted export file.

Hi,

first of all, be sure that export file is not copied in ASCII mode.

if so, You can do:

• take a look at import log. find where it's cancelled
• I guess internal data structers in export file is not so big. It's so likely that corruption occured on your data. modify binary export file by an binary editor. there may be a note in metalink which explains some structures in expor files.

hope this helps...

Mohit Goyal wrote:

> hi all,
> how to take an import from a corrupted export file. the error message is
> abnormal end of expoort file.
> Thanks,
> Mohit
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohit Goyal
> INET: mohitgoyal_at_delhi.tcs.co.in
>
> 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).

--
Use itrprof SQL Analyzer.

It formats SQL_TRACE/Event10046 traces and gives tuning advises.

It's web based, no download, no configuration.
Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.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).