-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|