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: Problem with Import Large Table

Re: Problem with Import Large Table

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 26 May 2003 19:42:45 GMT
Message-Id: <pan.2003.05.26.19.42.42.434547@adelphia.net>


Let me add another value to your many values: buffer=10485760

On Mon, 26 May 2003 13:26:56 +0200, Marek Stojecki wrote:
> Hello
>
> I have exported large table (166 colums) direct path on Oracle 8.1.7.4
> Enterprise Edition Solaris Sparc (64-bit).
>
> I import database to Oracle 8.1.7.4 EE on RedHat 7.3
>
> And :
>
> IMP-00020: kolumna typu long za duża dla bufora kolumn (rozm. 1)
> (column long type to big for the column buffer )
> occurs,
>
> I was trying many different values of the buffer - imp parameter.
>
> Thank You in Advance for Help
>
> Marek Stojecki
>
> Oracle DBA

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds 
Received on Mon May 26 2003 - 14:42:45 CDT

Original text of this message

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