Fastest/Best method to create MVs for over 600 tables
I am currently setting up materialized view replication for an application that contains almost 600 tables. I am at the stage where i am creating the materialized views, and the process is taking a long time. The two databases exist in different countries. What is the best practice/ recommended method for creating MVs when there are so many tables?
I am thinking that I can export from master site/import at MV site (which is local), and create the MVs off the tables locally at the MV site. Is this reccommended??
Thanks in advance,
Christine