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 ?

  • 1
    What does "moving" mean to you? I would read that to mean something like "taking an RMAN backup, shutting down the existing database, restoring the backup on the new server, starting up the database". But if that's what you're doing, I don't see why you would need to re-create anything. Commented Aug 5, 2014 at 16:48

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.