DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: IMP-00020: long column too large for column buffer size??

  1. #1
    Join Date
    Oct 2002
    Posts
    182

    IMP-00020: long column too large for column buffer size??

    importing and getting this error.
    why would I get this error if there is no LONG column on the table???

    error:
    PHP Code:
    . . importing partition "METER_INTERVAL":"D2003_09_23"
    IMP-00020long column too large for column buffer size (30)
    . . 
    importing partition "METER_INTERVAL":"D2003_10_15"
    IMP-00020long column too large for column buffer size (30
    - Cookies

  2. #2
    Join Date
    Oct 2002
    Posts
    182
    this is a bug.

    solution:

    If you export the data with DIRECT=N and BUFFER=2000000
    then everything seems to work fine on the import
    side using buffer=2000000

    stupid Oracle.

    close thread
    - Cookies

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