title: How to insert LONG BINARY from SQL Server to Oracle
body: <p>I need to get a copy of a SQL Server 2008 table into an Oracle RDBMS. I have database link for SQL Server, database has a table which contains LONG BINARY type column. </p>
  
  <p>When I issue </p>
  
  <pre><code>create table test_ora as select * from mssqltable@dblink 
  </code></pre>
  
  <p>I get the error </p>
  
  <blockquote>
    <p>Can't convert LONG</p>
  </blockquote>
  
  <p>I tried to use <code>to_lob</code>, <code>to_char</code>, <code>hextoraw</code> and a ream of Oracle conversion function but still hasn't defeated the issue. Do you have any ideas? </p>
  
  <p>p.s. I'm out of work now so can't tell exact <code>ORA-</code> error number.</p>