I have tried using char(4000) in the control file for the rawtext fields and still I get the same error. I thought that using the filler keyword would cause sqlldr to just skip the entire field no matter how long it is, because I don't want to load that data at all.

So I guess my next question is how do I skip loading a field that is larger that 4000 characters?

Load DATA
INFILE *
REPLACE
INTO TABLE T 
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
name char(255) enclosed by '"', 
contactemail char(255) enclosed by '"', 
rawtext1  filler char(20000) enclosed by '"', 
rawtext2  filler char(20000) enclosed by '"', 
auditdate char(255) enclosed by '"' 
)
BEGINDATA
"name1","email1","[15000 byte string]","rawdata2","audit1"
"name2","email2","[15000 byte string]","rawdata2","audit2"

SQL> select * from t;

NAME
-------------------------------------
CONTACTEMAIL
-------------------------------------
AUDITDATE
-------------------------------------
name1
email1
audit1

name2
email2
audit2

That worked brilliantly. I did not know that you could specify a value greater that 4000 in a char so I never tried anything higher. Thanks so much.

I am working on a CTL file which expects one of the column to have more than 16000 characters which we want to skip from loading to table.

Table: XXAP_CHR_EXP_LINE has column XXAP_CHR_EXP_LINE as CLOB

CTL: XXAP_CHR_EXP_LINE FILLER CHAR(20000) OPTIONALLY ENCLOSED BY '"'
which is interpreted as:
EXPENSE_LINE_ITEM_GUESTS NEXT 20000 | O(") CHARACTER
(FILLER FIELD)

When we run this with a data having data column around 15000 chars then also it is failing saying 'ORA-01461: can bind a LONG value only for insert into a LONG column'.

I also checked with 10000 chars then it works fine. Not sure why it's not working with CLOB. Even if I change the CHAR length in CTL more than 20000 say 50000 then also it's not working.

Regards,
Shobhit