Re: Oracle Import Error

Hi Don,

the error you got has nothing to do with swap space or sga size. Call "imp help=y", then you'll see all the parameters available. One of them deals with buffer size. The varchar2(2000) produces this error. Set the buffersize to 3000 or even more.

Good luck

Hans

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
Received on Sun Aug 30 1998 - 12:46:15 CDT