My requirement is to load a data file to a table which may have more than 4000 char per line. So, I can't use varchar column in the table. So, I have a table as below.
create table test_clob
(col1 clob)
created a control file as below.
LOAD DATA
INFILE 'data.txt'
BADFILE 'data.bad'
DISCARDFILE 'data.dsc'
APPEND INTO TABLE your_table
FIELDS TERMINATED BY ',' TRAILING NULLCOLS
(
clob_column LOBFILE(clob_data) TERMINATED BY EOF
)
now, when I am trying to load data by the belwo sqlldr command, I am getting error..
sqlldr username/password control=control_file.ctl
error :
SQL*Loader-416: SDF clause for field COL in table TEST_CLOB references a non existent field.