if ur table is not hving a long column, it could be bug #230777
the imp file could be corrupted.
hv u tried using a fresh new export dump with larger buffersize. then try
importing this new export.
-Mandar
> -----Original Message-----
> From: Antonio Idone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: IMPORT Error - IMP-00020: long column too large for column
> buffer size
>
>
> Hi list,
>
> 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
>
> thanks
> Antonio
> ______________________________________________________________
> _____________
> Visit http://www.visto.com/info, your free web-based
> communications center.
> Visto.com. Life on the Dot.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Antonio Idone
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Ghosalkar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
