Re: Oracle import column buffer too small

You can user BUFFER parameter during import. Specify a large buffer close to 100000 and retry. See if it works, if it does not then increase it by 20000 and again try. Repeat in case you get error.

-----Information related to error message---> 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 (for example) up to 66,000 or greater. Use this step-by-step approach because a buffer size that is too large may cause a similar problem.

Hope this helps,

Manoj Jain

In article <6sa926$tbi$1_at_nnrp1.dejanews.com>,   don_cut_at_my-dejanews.com wrote:
> I am trying to import a table with around 2.9 million records the table. the
> table contains 5 number(15) columns, 1 char(25) column and 1 varchar2(2000)
> column. at around the same point in the import i get an import error
> imp-00020 long column too large for column buffer size. i have a large sga
> around 130M from db_block_buffers and around 60M from shared_pool, and the
> import buffer is just under 2G. there is also 4G of swap space on the
> server, and nothing else other than this oracle database, and this database
> is void of any other non-system tables. any suggestions? - how can i make
> the column buffer larger?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Aug 30 1998 - 04:20:10 CDT