Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMP-00020 Error ???

Re: IMP-00020 Error ???

From: Mehul Zaveri <mehulzaveri_at_hotmail.com>
Date: Tue, 14 Sep 1999 18:01:53 +0400
Message-ID: <7rlk6a$e33@news.emirates.net.ae>


It looks like, your export file is corrupted/incomplete. Did you do ftp? If it is so, do ftp with binay mode on.
try to recreate the .dmp where there is enough disk space.

Mehul Zaveri,
Oracle DBA
EPPCO-DUBAI Wim Teuwens <Wim.Teuwens_at_Technum.Be> wrote in message news:7rl0ml$rra$1_at_news3.Belgium.EU.net...
> Hi,
>
> When doing a full import into a new,clean database I got the message
>
> . importing GEOOV's objects into GEOOV
> . . importing table "ARMATUUR"
> IMP-00020: long column too large for column buffer size (4)
> IMP-00028: partial import of previous table rolled back: 606 rows rolled
> back.
>
> Table ARMATUUR has no longs !
>
> Also, when the import passes another table it gives this:
>
> . . importing table "STEUN"
> IMP-00009: abnormal end of export file
> IMP-00028: partial import of previous table rolled back: 567 rows rolled
> back
> Import terminated successfully with warnings.
>
> The Export was generated by the EXP73.EXE command line.
> Database : Oracle 7.3.4
> OS : NT4 SP3
>
> What's the problem here ? Anyone Ideas ?
>
> Thanx.
>
> Wte_at_anaXis.be
>
>
>
>
Received on Tue Sep 14 1999 - 09:01:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US