I have a table in the Sybase database table called "dNSP". This table has 2
fields called Terms and Justificationcomments which are of datatype text and
have a length of 16. I am using a BCP Utility to save the contents of the
table to a tab delimited flat file. Then, I am using SQL*Loader to load the
contents of the flat file to a table in Oracle. However, it loads only 36177
records out of a total of 46578 records. Looking at the log file, it
complains about the lengths of the Terms and Justification fields. The
message is "Fields in data file exceeded maximum specified length". I have
specified the two fields to be of type varchar2(2000) in the Oracle table.
After analyzing the two fields of the "dNSP" table in the Sybase, the length
of the "Terms" field is 1930 characters and the length of the
"JustificationComments" field is 300 characters. Therefore, I should have
enough space to accomodate the two fields in the Oracle table since the two
fields are of type varchar2(2000) respectively So, why am I getting the
message "Fields in data file exceeded maximum specified length"?
Received on Wed Jul 12 2000 - 00:00:00 CDT
