title: What are the different methods to import a table with CLOB column into Oracle
body: <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>