title: Copy data from view to a table
body: <p>I created a table <code>DBA_DATA_FILES_HIST</code> to store all the info from <code>DBA_DATA_FILES</code> view. When I run the following query, i get an error that the table <code>DBA_DATA_FILES</code> does not exist. I'm using Oracle.</p>
  
  <pre><code>SELECT *
  INTO DBA_DATA_FILES_HIST
  FROM view DBA_DATA_FILES;
  </code></pre>