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 18.104.22.168 to 10.2.0.3 [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 22.214.171.124, 126.96.36.199, 10.2.0.2 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