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 Sat Aug 29 1998 - 20:14:46 CDT
