sql loader problem -- missing first character

[rmutyapu]

I am loading data using the SQLLDR utility of Oracle. I defined one column as seq. I am loading the data, it is working properly but next column is not loaded correctly.

Problem :

First Character in the second column was missing. Please help me how to correct the ctl file.


Table:

CREATE TABLE SEQ_TAB1 (
A_ID NUMBER (10) NOT NULL,
A_NAME VARCHAR2 (25) NOT NULL,
A_TYPE VARCHAR2(25)
);

Seqence : t_seq1 (a_id)

Data file:

Alabama,first
Alaska,ice
California,hot
Texas,time

CTL file :

LOAD DATA
APPEND INTO TABLE seq_tab1

(
a_id "t_seq1.nextval" ,
a_name char terminated by "," ,
a_type char terminated by ","
)

Command :
sqlldr username/password@service_name control=ctl_file log=log_file data=data_file

The following way data has been loaded into the table.

1,labama,first
2,laska,ice
3,alifornia,hot
4,exas,time

 

[ThomVF]

Try using single quotes for the termination string:
',' versus ","

That's the only possible problem I can spot... =================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com