Did you check if open_cursors is set to 300 ?
don_cut_at_my-dejanews.com a écrit dans l'article
<6sa950$tke$1_at_nnrp1.dejanews.com>...
> 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 Mon Aug 31 1998 - 06:42:20 CDT
