title: Creating new table with SELECT INTO in SQL
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2250196/select-into-using-oracle">SELECT INTO using Oracle</a>  </p>
  </blockquote>
  
  
  
  <p>I have came across <code>SQL SELECT INTO</code> statement for creating new table and also dumping old table records into new table in single SQL statement as</p>
  
  <pre><code>  SELECT * INTO NEW_TABLE FROM OLD_TABLE;
  </code></pre>
  
  <p>But when i am trying the above query it is giving error as <code>ORA-00905: missing keyword</code></p>
  
  <p>Is it possible to do that in ORACLE ?</p>
  
  <p>Thanks.</p>