New answers tagged materialized-view
If a materialized view is already fast refreshable, the DBMS_ADVISOR.TUNE_MVIEW procedure will return a message saying "the materialized view is already optimal and cannot be further tuned" So there is nothing to do.
If you are moving the database (backup on old server and restore on new server) the MVs will come along. Are you creating an empty database on the new server? If so you could use Data Pump to export the MVs from the old and import them into the new. I would opt for using a full RMAN (or filesystem) backup and restore over Data Pump.
Top 50 recent answers are included