General discussion

Locked

SQL*Loader Error Message

By Timothy.Nelson ·
I am trying to load data from a flat file into an Oracle table and getting an error message of Field in data file exceeds maximum length for values in a column that exceed 256 characters. The field size on my source database, which I am creating theflat file from, is a VARCHAR2(500) and in my temp table, which I am trying to load the data into when I'm getting this error message, has a VARCHAR2(1000) field size. I'm not understanding why this is happening. Can anybody help me?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL*Loader Error Message

by john_wills In reply to SQL*Loader Error Message

Take a look at the flat file: it may turn out that the download from the source database is not working right.

Collapse -

SQL*Loader Error Message

by Timothy.Nelson In reply to SQL*Loader Error Message

I just received an answer to this question from another source. What happened was that in SQL*Loader it has a max length of 256 for loading varchar2 columns, so we had to trick the system by putting in the control file for this field char(1000) to get it to load.

Collapse -

SQL*Loader Error Message

by Timothy.Nelson In reply to SQL*Loader Error Message

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums