title: Create table as select * from sql server with 'ntext' datatype
body: <p>I have a db-link from an oracle 11 database to a SQL server database. I am trying to perform a <code>ctas</code> from a table in the SQL server database, however for every table with a column of datatype <code>ntext</code> I get the error:</p>
  
  <blockquote>
    <p>ORA-00997: illegal use of LONG datatype. </p>
  </blockquote>
  
  <p>How can I solve this issue? Even if I was willing to forget about those specific columns, I have about 300 tables to perform the same action on.</p>