IMP-20 Long column too large for buffer size

[kris123]

Hi Friends,

I got this error IMP-20 when importing a table
from export file. I do not have a long
columns on my table and increasing buffer size
does not work also.
O.S. AIX 4.3.3
Oracle 8.1.6

Help me please...

Thank you all

[prakashs43]

1) are us trying to import on the same server ?
if u are trying on other server
just check if u have transferred the file in binary format .
th eexport dump might have corrupted .

2) if the above situation is OK then just try importing
with diffrent combinations of the following parameters .
recordlength=655360 or commit=Y and don't set buffer parameter in ur par file .

[kris123]

Hi Friend,

I'm importing on the same server. I also tried to import show=y
to browse all the constents of the file and its ok. Only one
table was affected.

I also tried commit=y and recordlength=655360 but the error
prevails. Any other suggestions pls?


Thanks