User tables and data dictionary views are shown for two master sites and two snapshot sites. There are two way arrows (representing network connections) between the following sites: - Master 1 and Master 2 - Master 1 and Snapshot 1 - Master 2 and Snapshot 2 Master 1 (m1) includes the following table: RS.emp ename dno sal ------------------ Smith 10 1000 Jones 10 1200 Leary 20 850 Jain 20 900 Master 1 (m1) includes the following data dictionary views: DBA_REPGROUP gname master status comment ------------------------------------------------- RS Y normal DBA_REPSITES gname dblink masterdef snapmaster comment ------------------------------------------------- RS m1 Y null RS m2 N null DBA_REPOBJECT gname oname type status comment ---------------------------------------------- RS emp$RR package valid RS emp$RR package_body valid RS emp table valid RS emp$RP package valid RS emp$RP package_body valid Master 2 (m2) includes the following table: RS.emp ename dno sal ------------------ Smith 10 1000 Jones 10 1200 Leary 20 850 Jain 20 900 Master 2 (m2) includes the following data dictionary views: DBA_REPGROUP gname master status comment ------------------------------------------------- RS Y normal DBA_REPSITES gname dblink masterdef snapmaster comment ------------------------------------------------- RS m1 Y null RS m2 N null DBA_REPOBJECT gname oname type status comment ---------------------------------------------- RS emp$RR package valid RS emp$RR package_body valid RS emp table valid RS emp$RP package valid RS emp$RP package_body valid Snapshot 1 (department 10) includes the following snapshot: RS.emp ename dno sal ------------------ Smith 10 1000 Jones 10 1200 snapshot emp is select ename, sal from EMP@m1 where dno=10 Snapshot 1 (department 10) includes the following data dictionary views: DBA_REPGROUP sname master status comment ------------------------------------------------- RS N null DBA_REPSITES sname dblink masterdef snapmaster comment ------------------------------------------------- RS m1 Y Y RS m2 N N DBA_REPOBJECT sname oname type status comment ---------------------------------------------- RS emp snapshot valid Snapshot 2 (department 20) includes the following snapshot: RS.emp ename dno sal ------------------ Leary 20 850 Jain 20 900 snapshot emp is select ename, sal from EMP@m2 where dno=20 Snapshot 1 (department 10) includes the following data dictionary views: DBA_REPGROUP sname master status comment ------------------------------------------------- RS N null DBA_REPSITES sname dblink masterdef snapmaster comment ------------------------------------------------- RS m1 Y Y RS m2 N N DBA_REPOBJECT sname oname type status comment ---------------------------------------------- RS emp snapshot valid