What are the different methods to import a table with CLOB column into Oracle
<p><a href="https://i.stack.imgur.com/jrJj7.png" rel="nofollow">Description of the table</a></p>

<p>This is my table.</p>

<p>And I have an excel file with two columns. The second column has a huge string.
Tried to import this table using SQLDeveloper 4.2.
Tried all formats like xlxs, csv, txt. But I get an error the following error message:
DATA IS NOT COMPATIBLE WITH COLUMN DEFINITION OR IS NOT AVAILABLE FOR A NOT NULLABLE COLUMN.
<a href="https://i.stack.imgur.com/GCRzz.png" rel="nofollow">error message on the CLOB column</a></p>

<p>Also tried setting both the columns as null and not null.</p>

<p>Please, help me resolve this issue.
I really appreciate if anyone can share me the various methods which can be applied in order to import huge files like this one.</p>

<p>Thank you!</p>