title: how to convert materialized view into normal view
body: <p>I am using Oracle 11g EE and created one Materialized view for a complex query.
  But as customer is using Standard edition and it doesn't support Materialized view.
  So I need to convert materialized view into a normal view.
  Along with this conversion I also need to make sure performance of a query.
  When I treid to execute a query for the view independently, it takes around 20 mins which is too much time.
  All my tables are indexed.</p>
  
  <p>Any sort of help would be appreciated !!</p>