title: Convert a materialized view into a table in Oracle 11g?
body: <p>I am running Oracle 11g and SQL Developer on the client. I have a materialized view that I would like to convert into an ordinary table. How can that be done?</p>
  
  <p>The only way I have come up with is to create a table with the same structure, export the data from the MV and import it to the table. However to do that I would have to manually create all the fields (30+) for the table to match those in the MV. So I figured there must be a better solution?</p>