All rights reserved.Ĭommit point reached - logical record count 2ĬUSTOMER_ID FIRSTNAME LASTNAME CUSTOMER_DETAILS I:\>sqlldr /tiger control=C:\TEMP\TMP_LOAD_CLOB_DATA.ctl So we prepare CTL file: LOAD DATAĬUSTOMER_DETAILS LOBFILE(CUSTOMER_DETAILS_CLOB_FILE) TERMINATED BY EOFĭata file C:\TEMP\TMP_LOAD_CLOB_DATA.TXT: 123ĚBC XYZĜ:\TEMP\TMP_LOAD_CLOB1.TXTĬlob file C:\TEMP\TMP_LOAD_CLOB1.TXT: Lot Of InformationĬlob file C:\TEMP\TMP_LOAD_CLOB2.TXT: Lot Of Information Well, since CLOB in general is multi-line text each clob needs to be stored as a separate file. How can I avoid adding the column size like char(50000) and still load the data into clob column? OPTIONS (DIRECT=TRUE, MULTITHREADING=TRUE, PARALLEL=TRUE) Assuming the data will look like shown below.ĬUSTOMER_ID FIRSTNAME LASTNAME CUSTOMER_DETAILSġ23 ABC XYZ Lot Of Information about the customer which should be loaded into clob For example the table structure looks like this. I tried searching for a solution everything I found is about lobfile which may not help here as we are not receiving the data in a separately alone for the specific column. Could you please let me know if there is any other possibility to load the data without specifying the size. Currently I am trying to load the data by extending the size of the column in control file every time which may not be good practice. We have a tab delimiter file which will be received on timely basis, apart from other column values there is one column which contains huge data which I am trying to load into a clob column, and we are not sure how big the data will be in that column as it is not specified. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.