I'm trying to use tOracleBulkExec as part of my design to load a huge flat file data
but I'm facing the below issue:
"Field in data file exceeds maximum length" for most of the fields.
In order to mitigate the
default datatype in SQLLDR - char(255) issue, I modified my control file to use the required length for all the fields as below
and checked the "Use existing control file" option to use the modified .ctl file. But, still ended up getting the same error. Any suggestions to resolve this error?
Could you please share the table DDL and also the current schema you are suing to load the data? I would also prefer Varchar instead of Char to save the space in DB.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
