error while doing import
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: error while doing import

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

    anandkl

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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]
    Reddy,Sam

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    what command you had given for import

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Thanks Reddy,
    I am working on sun 2.7.Whats the max size for the buffer.

    regards
    anandkl
    anandkl

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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)
    anandkl

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Looks it like a bug... check metalink doc # Note:110554.1
    Reddy,Sam

  8. #8
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

  9. #9
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi reddy,
    Thanks for the link.I finally got the solution.Thanks for the help

    regards
    anandkl
    anandkl

  10. #10
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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...
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width