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?
Thanks in advance
Received on Sat Aug 29 1998 - 20:14:01 CDT
