title: how to transfer CLOB data from one database to another remote ORACLE database having DBLinks
body: <p>The problem is, how to transfer CLOB data from one source database to another Oracle database, having DBLinks.</p>
  
  <p>Oracle cannot transfer CLOB data using DBLinks so what kind of solution we can have apart from: extending fields in Oracle to Varchar2 32.767 characters (new feature of Oracle 12).</p>