Re: Long column too large during import

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 24 May 2004 14:11:14 GMT
Message-ID: <6onsc.14055$No1.9889@nwrddc02.gnilink.net>

"zeb" <spam_at_nowhere.com> wrote in message news:40b0e471$0$6101$626a14ce_at_news.free.fr...
> >
> > > . . importing table "DHACCMVT"
> > >
> > > IMP-00020: long column too large for column buffer size (7)
> > >
> > // *Cause: The column buffer is too small. This usually occurs when
> > importing
> > // LONG data.
> > // *Action: Increase the insert buffer size 10,000 bytes at a time (for
> > // example). Use this step-by-step approach
> > // because a buffer size that is too large may cause a similar
> > // problem.
> >
> > Mind the last line... your buffer may be too large.

>
> OK thanks
> I imported 10 times ( 11M rows !!!)
> from buffer=30000 to  150000
> with no success ( same error )
> Any ideas ???
>
>

Usually this error is related to a direct export. But I see that you had done a conventional export. This error can also be caused if the export file is corrupt. Try exporting/importing just this one table.

Anurag Received on Mon May 24 2004 - 09:11:14 CDT