Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Loader fails to process string columns with more than 255 characters

745723Jul 19 2010 — edited Jan 10 2011

Hi all,

I am using LKM file to sqlldr(oracle) to load data from flat file to oracle. I am aware of the fact that if you don't specify length of the input character data, sqlldr uses default of 255 characters. But, in my source datastore I have specified the column length to be 1000, but sqlldr still fails to process records with more that 255 characters.

Any idea how to change this behavior of sqlldr?

Appreciate your response.

Akshata

This post has been answered by Ankit J on Jul 19 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2011

Added on Jul 19 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

5 comments

1,647 views