title: How to copy table having CLOB column from one user to another in Oracle
body: <p>I have group of tables which should be copied from one user to another user. I wrote a procedure which copies all the tables when I run it. One of the table has CLOB column which shows error when I run the procedure.</p>
  
  <p>I tried  </p>
  
  <pre><code>insert into destination_table_name values(select colume_name from source_table_name);
  </code></pre>
  
  <p>But the table has 20 columns so above one cannot be used. Kindly help me to fix the error.</p>
  
  <p>The actual error message is:</p>
  
  <pre><code>"**ORA-22992: cannot use LOB locators selected from remote tables**"
  </code></pre>