CODEWITHSUNDEEP
oracle-databasesql-loader
I_am_groot
I_am_groot

Reputation: 49

How to insert a string of size more than 4000 bytes into table column of type CLOB using SqL ldr

I am trying to load a string of length more than 4000 into table of column type CLOB. I know we can do this using ananymous block. But how can I use this block in control file?

Upvotes: 0

Views: 578

Answers (1)

Popeye
Popeye

Reputation: 35900

You need to provide the max size of the clob as following:

LOAD DATA
INFILE <your_filename>
INTO TABLE <your_table_name>
FIELDS TERMINATED BY '<your_separator>'
TRAILING NULLCOLS
(
id,
<your_clob_column>    CHAR (6000), -- max value of your clob col, default is 255
other_fields
)

see the default is 255 so it will throw an error if you do not specify the size and load the data with length > 255 so It is better to always use size as mentioned above.

Cheers!!

Upvotes: 1

Related Questions