Re: Import error IMP-00020 under Oracle 7.3.3

From: Alan Moor <asmoor_at_ix.netcom.com>
Date: Thu, 26 Aug 1999 18:30:22 -0400
Message-ID: <7q4f6r$9nv_at_dfw-ixnews16.ix.netcom.com>


Obviously, your Spalte is too big for your Spaltenpuffer.

But really, the table has a long column. Make sure you specify "buffer=102400000" (puffer=102400000?) on the import. Make the size large enough for the longest long column + 1 block. Also specify "commit=Y" so you don't run out of rollback segment.

Tscheuss,
Alan

M. Schulze wrote in message <37c54da1.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
>
>
>
Received on Fri Aug 27 1999 - 00:30:22 CEST

Original text of this message