Re: Problem with Import Large Table

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 26 May 2003 19:06:57 +0200
Message-ID: <ebi4dvo41t25mjfkku2ggoanv4pllhmvon@4ax.com>

On Mon, 26 May 2003 13:26:56 +0200, "Marek Stojecki" <marco100_at_poczta.fm> 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

'Many different values of the buffer imp parameter' doesn't say anything. I usually start with 8m. Increasing the buffer parameter is the only way to resolve it, apart from stop using the obsolete LONGs

>
>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 26 2003 - 12:06:57 CDT