Re: oracle 7 import problems

Don C. wrote in message <35E8A74E.5778FD05_at_yahoo.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?
>

What's the value of buffer parameter in imp's command line ? If you did not specify it you might experience such problem. Try with buffer=2000000 or higher.

HTH,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Mon Aug 31 1998 - 02:24:33 CDT