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?