Database DataWarehousing (MOSC)

MOSC Banner

Materialized views and export/import

edited Jun 11, 2013 5:35AM in Database DataWarehousing (MOSC) 8 commentsAnswered ✓
Hi,
Suppose we have a huge list of mviews located in the database B with all master tables for these Mviews located remote in database A.
Suppose we have to move database B from one host to another host using export/import (database sid for database B will be the same, but DBID changed).
Question:
After the import, will mview fast refresh works or do we have to recreate all mviews again from scratch ?
Which information is stored at master site to recognize the database asking for a mview refresh ?


With Rgds
/Chris

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center