0 Replies Latest reply: Apr 7, 2011 7:11 AM by ADaniel RSS

    materialized view based on with rowid option - created with datapump

    ADaniel
      Hi

      I am trying to create a materialized view for a table that has 300milion+ rows. The server on which the materialized view will be is not very fast and of course I don't really want to have the view in refresh mode 3 weeks.
      Right now I started the refresh on the view and after 2 days it is at 13% completed.

      My question is: can datapump be used for this kind of materialized view (with rowid option)?

      On a primary key based MV, I could import the table and create the MV based on the existing (created at import) table. But for a rowid based MV, can it be done?

      Thank you