My Oracle Support Banner

INCORRECT / TRUNCATED Data Getting Inserted Through Sql Loader (Doc ID 444442.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 10.2]
Information in this document applies to any platform.


When trying to load data through sqlloader for a specific column of type CHAR or VARCHAR2 or CLOB, data is getting truncated.

B is the column in TABLE1 having the problem.


SQLLDR command :

First character of the remaining lines (except the first row) getting truncated and also the new line character getting truncated.

Issue is reproducible in,, in all Unix platforms. 

The issue is Not Occurring in WINDOWS.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.