How to load col which have CLOB data type ,col having data length more than 500 char using sqlloader
I have tab delimited file which has 15 columns. Out of 15 columns there is one column which has a size of more than 4000 characters. This particular column is of CLOB datatype, while the rest of them are of varchar. This file has around 26000 records in it. Now I am using SQL loader to load all these records to load the data in Oracle database. My problem is that I am not able to load the CLOB data value in database. Please note that there is no separate file for CLOB data. As CLOB data is within the