> -----Original Message-----
> From: Antonio Idone [mailto:[EMAIL PROTECTED]]
>
> 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.
