Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: IMPORT Error - IMP-00020: long column too large for column bu

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

From: Mandar Ghosalkar <MandarG_at_gsr-inc.com>
Date: Fri, 23 Mar 2001 17:50:38 -0800
Message-ID: <F001.002D6E9D.20010323175101@fatcity.com>

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:antoidone_at_visto.com]
> 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: antoidone_at_visto.com
>
> 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: ListGuru_at_fatcity.com (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: MandarG_at_gsr-inc.com

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: ListGuru_at_fatcity.com (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).
Received on Fri Mar 23 2001 - 19:50:38 CST

Original text of this message

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