title: Is there a way to export a table with large CLOB entries to a flat file?
body: <p>I am trying to export tables from an Oracle 10g database that contains CLOB data. Some entries consists of large text fields, or specifically in my case, xml files. When trying to export such a table to a flat file, the data in the CLOB gets truncated at ~4000 bytes.</p>
  
  <p>The method I've been trying to use to export the tables are the "Export Database" tool in SQL Developer, exporting to multiple flat file formats (csv, tsv, dsv files..) with different settings. However, it seems as there is some buffer (or similar) that limits the data size and truncates data for all the tested formats. </p>
  
  <p>Does anyone know if this is true? I have not found any such setting (yet, at least). Or if this method is even capable of export such data?</p>
  
  <p>For reference, it successfully exports my largest tables (that do not include CLOB) of about 300 mill rows and a resulting file size of ~12 GB.</p>
  
  <p>The reason for this export is to move the data to an MSSQL database and import it there using BULK INSERT method. The database schema structure is the same (created by the application we use (Teamcenter) that supports both DB systems.) in both Oracle and MSSQL.</p>
  
  <p>Any tips / recommendations is welcome, and if there is another way that should be investigated, suggestions are most welcome.</p>
  
  <p><strong>EDIT</strong> (17th of March 2020) - For others in the same situation:
  Postet my solution as an answer as per good feedback from @MT0 (Better late then never)</p>