RE: IMPORT Error - IMP-00020: long column too large for column bu

> -----Original Message-----
> From: Antonio Idone [mailto:antoidone_at_visto.com]
>
> i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00
> A 9000/800.
> The folling tables Import terminated successfully         
>
> AGG_CTR_SEDE_TRG_R
> V_DOC_AGREE_CTR_R
>
> but :
>
> . . importing table           "AGG_CTR_SEDE_TRG_R"
> IMP-00020: long column too large for column buffer size
> (2)raoul oracle
>
> i have used buffer with 64k, 100k, 4M  10M 20M  40M  50M 
>
> 60,80,100M but don't work
>
> IMP-00006: failed to allocate memory of size 100000000
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> IMP-00000: Import terminated unsuccessfully

Could it be that your buffer size is getting too large? Here's what the Oracle error messages manual says:

IMP-00020: long column too large for column buffer size num 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 up to 66,000 or greater (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem. Received on Fri Mar 23 2001 - 19:56:24 CST