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: Long column too large during import

Re: Long column too large during import

From: zeb <spam_at_nowhere.com>
Date: Sun, 23 May 2004 19:56:05 +0200
Message-ID: <40b0e471$0$6101$626a14ce@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 ??? Received on Sun May 23 2004 - 12:56:05 CDT

Original text of this message

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