Re: Oracle import column buffer too small

Ran into similar problems myself once:
Increase the buffer parameter of the import command. This will probably resolve it. In my case having a too small buffer resulted in pl/sql procedures to become truncated and the import command out of sync. Also make sure you use the same recordlength, the recordlength you specified with export. Different record lengths are also a source of trouble.
Hth
Sybrand Bakker, Oracle DBA

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 - 01:36:21 CDT