Buffer Size -
11-12-2004
, 11:58 AM
Hi,
I am trying transfer data from Excel file to database using Datapump.
I have few 10 rows empty for a column and 11th row has lot of data with CRLF
and LF. The datapump is complaining about the size of the data. I am
getting message
"Data at source column 9 is too big than the allotted buffer size"
If I copy that cell data into a a separate file, the size of the file is
around 2960 bytes and the disk size is 4KB. and in the properties of the
Datapump, I changed the buffer size to 9999 and column size in the database
is 8000.
And I am still getting the same error.
Any suggestions?
thanks,
Sreenath |