I'm learning the replication concept in oracle database. I have a confusion of these two terms – master site and materialized view site. Please help on this…
Oracle – Difference Between Master Site and Materialized View Site
oraclereplication
Related Question
- Why not use a table instead of a materialized view
- Oracle – How to View Original Script of Materialized View Created by Another User
- Oracle – Materialized View Overloads Database
- Materialized view became INVALID and USER_MVIEWS.COMPILE_STATE becomes ‘NEEDS_COMPILE’
- Oracle – Proper Procedure for Fixing Materialized View Replication
- Oracle – Fix Materialized View Not Purging Over dblink
Best Answer
Let's say I have two databases,
DB1
andDB2
. I want to replicate data fromDB1
toDB2
. I created materialized views onDB2
and these materialized views gets data (periodically) from tables stored onDB1
.So which is master site here? The database from which replicated sites(
DB2
which has materialized views) gets data. In other words the database which stores master tables , which isDB1
in our case.then materialized view site? The database which stores the materialized views, which is
DB2
.Documentation: About Master Sites, Master Tables, and Materialized View Sites