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

Thread: Data too big

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    I have data in Excel which I am trying to transfer in Oracle - 8.1.6 . There is one particular text field in the source which has like a maximum of 300 characters. But in my destination table - the corresponding field is of datatype LONG. But I get an error saying 'data too large for the column'. Anyone has any ideas on what could be wrong ?

    Thanks,
    Shiva.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    According to revealnet this is common. You have to set longchunksize, otherwise it will default to whatever it is set to.
    SET LONGCHUNKSIZE n
    N= amount of charachters.
    (The default is 80)
    MH

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