error while doing import

[anandkl]

Hi friends,
I am getting this below error when i try to import.

IMP-00020: long column too large for column buffer size (1)

I tried to do a step by step of increasing the buffer size still it dint work.More over my table does not have any column with long data type.If any one has encountered this problem and sloved it please guide in solving this problem

regards
anandkl

[sreddy]

PEr conversation with Oracle support couple of years ago, you have two alternatives:

Give the maximum allowable buffersize on the box and import it
OR
Write some program to bring LONG datatype to database.

First option did work for me. That time I was bring 8.0.x database to 8.1.6 Not sure if something changed in between to deal with LONG datatypes.


[Edited by sreddy on 08-12-2002 at 10:07 AM]

[shailendra]

what command you had given for import

[anandkl]

Thanks Reddy,
I am working on sun 2.7.Whats the max size for the buffer.

regards
anandkl

[sreddy]

It depends upon the amount of memory you have on the box.
Use a large BUFFER size. This value also depends on system activity, database size, etc. Several megabytes is usually enough, but if you have the memory some can go higher. Again, check for paging and swapping at the OS level to see if it is too high. This reduces the number of times the import program has to go to the export file for data. Each time it fetches one buffer's worth of data.

[anandkl]

This is my imp command and still i get the error
imp ananda/ananda file=/perf/dba/exp/reg.dmp buffer=100000000 commit=y constraints=no grants=no indexes=no fromuser=andale touser=ananda ignore=yes


MP-00020: long column too large for column buffer size (1)

[sreddy]

Looks it like a bug... check metalink doc # Note:110554.1

[anandkl]

Hi reddy,
I tried all the options listed in metalink,
but still i am getting the error.

Can u please help me on this

regards
anandkl

[anandkl]

Hi reddy,
Thanks for the link.I finally got the solution.Thanks for the help

regards
anandkl

[sreddy]

Whats the solution. I appreciate if you post the solution what you found on your own. It helps others who might hit the same problem...