Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help with Import!

Re: help with Import!

From: TurkBear <noone_at_nowhere.com>
Date: Fri, 27 Jul 2001 14:55:41 -0500
Message-ID: <smh3mtohdsoksi0qt92doug5sf92fulk3t@4ax.com>

Are you importing LONG datatypes?

Here's more detail on that error message:



IMP-00020
IMP-00020 long column too large for column buffer size num

Cause:The column buffer is too small. This usually occurs when importing LONG data.

Action:Increase the insert buffer size 10,000 bytes at a time (for example) up to 66,000 or greater. Use this step-by-step approach because a buffer size that is too large may cause a similar problem.


"Glen A Stromquist" <stromqgl_at_alpac.ca> wrote:

>Correction - thats an IMP-00020 not an ORA-00020 error....
>
>
>
>"Glen A Stromquist" <stromqgl_at_alpac.ca> wrote in message
>news:tCi87.3975$b_3.442902_at_news0.telusplanet.net...
>> I did an export of a table that has a large number of chained rows in it
 for
>> the purpose of re-importing to correct this. My .imp parfile has the same
>> number for buffer= (40000) as the .exp parfile, but I get the ORA-00020
>> error. Increased by 10k, same error and it stops at the same number of
 rows
>> each time.
>>
>> If it exported ok with this should it not import as well?
>>
>> Should I bump the buffer= way up? the server has 256meg ram.
>>
>> The column that is giving me grief is a long raw.
>>
>>
>> thanks in advance
>>
>>
>>
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jul 27 2001 - 14:55:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US