title: Oracle create table as select with count max condition
body: <p>I've got an Oracle problem, here is my select:</p>
  
  <pre><code>create table new_table as 
  select
  idprod as product_id, descr as description
  from old_table p where updateNum = (select max(updateNum) from old_table pp where pp.idprod = p.idprod);
  </code></pre>
  
  <p>this query gives me one generic error with no explanation. SQL Developer say me:</p>
  
  <blockquote>
    <p>"Error starting at line 7 in command: [...] Error report:<br>
    SQL Command: create table<br>
    Failed: Warning: execution completed with warning" </p>
  </blockquote>
  
  <p>but create the table and the data inside seems to be correct.</p>
  
  <p>Some hints?</p>