Materialized views and export/import
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
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
0