I am moving a database with 200 materialized views into a new server. All of them are 'fast refresh' materialized views , means they have corresponding materialized view logs, in this case sitting on another database.
I have spent countless hours tuning my 200 materialized views and would hate to re-create them in the new server (database).
Is there a way to move them without having to re-create them ?