title: Oracle Create Table AS and table comments and column comments
body: <p>Is it possible to create another table as CREATE TABLE AS and also preserve columns' comments ?</p>
  
  <p><br>
  <code>CREATE TABLE TABLE1_COPY AS SELECT * FROM TABLE1;</code><br></p>
  
  <p>The previous statement does not include columns' comments. Therefore TABLE1_COPY is left without columns' comments. Is using USER_COL_COMMENTS the only way to reproduce the same comments on my newly created table too?</p>