title: Table with TEXT datatype in MySQL not getting copied to Oracle
body: <p>I have never used mysql but in one of my recent work I have to create a table in Oracle using DB link which connects to MySQL DB.</p>
  
  <p>The table I want to copy has a column with datatype as TEXT</p>
  
  <p>from oracle I try to fire this command </p>
  
  <pre><code>create table test_table
  as
  select * from &lt;MYSQL_TABLE&gt;@DBLINK;
  </code></pre>
  
  <p>I get following error</p>
  
  <pre><code>Error report - SQL Error: ORA-00997: ugyldig bruk av datatypen LONG
  00997. 00000 -  "illegal use of LONG datatype"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>I tried to use to_char() function while creating the table </p>
  
  <pre><code>create table test_table
  as
  select to_char(col_with_TEXT_datatype) from &lt;MYSQL_TABLE&gt;@DBLINK;
  </code></pre>
  
  <p>it gives following error</p>
  
  <pre><code>ORA-00932: inkonsekvente datatyper: forventet CHAR, fikk LONG
  00932. 00000 -  "inconsistent datatypes: expected %s got %s"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Can someone tell me how can I create this table in Oracle.</p>
  
  <p>Please note that this is not one time activity, this table creation will be part of a weekly job schedule via procedures. So this has to be achieved through create table statement only.</p>
  
  <p>thanks in advance.</p>