3

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 ?

Improve this question
1
  • 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.
    – Justin Cave
    Aug 5 '14 at 16:48
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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