Re: Import error IMP-00020 under Oracle 7.3.3

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 26 Aug 1999 11:32:41 -0400
Message-ID: <7q3mrs$qf3$1@autumn.news.rcn.net>

Hi Mick,

M. Schulze wrote in message <37c54c8b.0_at_news.arcor-ip.de>...
>Hello.
>
>We try to make an import of our database, but we get always this
error
>
>. Tabellenimport: "ARTCHOUTHIS"
>IMP-00020: lange Spalte zu groß für Spaltenpuffer (22)
>IMP-00028: Partieller Import der vorherigen Tabelle
zurückgesetzt: 111910
>Zeilen zurückgesetzt
>
>Sorry, its in german, but maybe you know the error IMP-00020 and
can tell me
>what do do ?
>
>Thanks,
>
>Mick
>
>

As you can see from the error message below your problem is the buffer size. Use the buffer parameter in the command line. Make sure that it is large enough to hold your largest row.

$ oerr imp 20
00020, 00000, "long column too large for column buffer size (%lu)"
// *Cause: The column buffer is too small for long column. // *Action: Increase the buffer size until it is big enough for the long
// columns being imported.
$ oerr imp 28
00028, 00000, "partial import of previous table rolled back: %lu rows rolled bac
k"
// *Cause: ORACLE error encountered when trying to import the table.
// *Action: Check the ORACLE error message and take appropriate message.
// Reimport the table is necessary. //

Regards
Jerry Gitomer Received on Thu Aug 26 1999 - 10:32:41 CDT