Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long column too large during import
>
> > . . 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 ???
Received on Sun May 23 2004 - 12:56:05 CDT
![]() |
![]() |