SQLLDR :Data not loaded completely

Shell Programming and Scripting
1

Hi ,

I am using below control file

LOAD DATA
APPEND
INTO TABLE LSHADMIN.EG
TRAILING NULLCOLS
(
STUDY CHAR
)

and the text file to load data is

CACZ885M2301

When I run below command:

sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl data=/home/appsuser/dataload/infile.txt

the only thing inserted into table is 'C'.
Pls help...

2

what's the length of the 'STUDY' column.
the default length of CHAR type is '1' and hence only one character is loaded if you dont have the size specified

3

Check out the .bad file if you have one (you should in the directory the command is issued).
If not add bad=filename into command and check out for errors regarding inserts.

4

I used terminated by clause
It worked :slight_smile: