title: Create Table from View - Oracle SQL SQL Error: ORA-01723: zero-length columns are not allowed
body: <p>I need to create a table from view with statement like </p>
  
  <pre><code>CREATE  TABLE NEW_TABLE AS
      SELECT *
      from VIEW
  </code></pre>
  
  <p>It is giving error message as below. It is not possible to create table from view (with Select * statement)?</p>
  
  <pre><code>Error report -
  SQL Error: ORA-01723: zero-length columns are not allowed
  01723. 00000 -  "zero-length columns are not allowed
  </code></pre>