Illustration repma002.gif shows user tables and data dictionary views for two master sites and two materialized view sites.

There are two way arrows (representing network connections) between the following sites:

Both master sites have a master group named rs, and both materialized view sites have a materialized view group named rs.

Master 1 (m1)

Master 1 (m1) includes the following table:

employees

employee_id last_name department_id salary
100 King 90 8340
101 Kochhar 90 6650
103 Hunold 60 9725
104 Ernst 60 5890

Master 1 (m1) includes the following data dictionary views:

DBA_REPGROUP

GNAME MASTER STATUS SCHEMA_COMMENT
RS Y NORMAL  

DBA_REPSITES

GNAME DBLINK MASTERDEF SNAPMASTER MASTER_COMMENT
RS M1 Y NULL  
RS M2 N NULL  

DBA_REPOBJECT

GNAME ONAME TYPE STATUS OBJECT_COMMENT
RS EMPLOYEES TABLE VALID  
RS EMPLOYEES$RP PACKAGE VALID  
RS EMPLOYEES$RP PACKAGE BODY VALID  

Master 2 (m2)

Master 2 (m2) includes the following table:

employees

employee_id last_name department_id salary
100 King 90 8340
101 Kochhar 90 6650
103 Hunold 60 9725
104 Ernst 60 5890

Master 2 (m2) includes the following data dictionary views:

DBA_REPGROUP

GNAME MASTER STATUS SCHEMA_COMMENT
RS Y NORMAL  

DBA_REPSITES

GNAME DBLINK MASTERDEF SNAPMASTER MASTER_COMMENT
RS M1 Y NULL  
RS M2 N NULL  

DBA_REPOBJECT

GNAME ONAME TYPE STATUS OBJECT_COMMENT
RS EMPLOYEES TABLE VALID  
RS EMPLOYEES$RP PACKAGE VALID  
RS EMPLOYEES$RP PACKAGE BODY VALID  

Materialized View 1 (department 10)

Materialized view 1 (department 10) includes the following materialized view:

employees

employee_id last_name department_id salary
100 King 90 8340
101 Kochhar 90 6650

Materialized view emp is:

SELECT employee_id, last_name, department_id, salary FROM employees@m1 WHERE department_id = 90;

Materialized View 1 (department 10) includes the following data dictionary views:

DBA_REPGROUP

GNAME MASTER STATUS SCHEMA_COMMENT
RS N NULL  

DBA_REPSITES

GNAME DBLINK MASTERDEF SNAPMASTER MASTER_COMMENT
RS M1 Y Y  
RS M2 N N  

DBA_REPOBJECT

GNAME ONAME TYPE STATUS OBJECT_COMMENT
RS EMPLOYEES SNAPSHOT VALID  

Materialized View 2 (department 20)

Materialized view 2 (department 20) includes the following materialized view:

employees

employee_id last_name department_id salary
103 Hunold 60 9725
104 Ernst 60 5890

Materialized view emp is:

SELECT employee_id, last_name, department_id, salary FROM employees@m2 WHERE department_id = 60;

Materialized View 2 (department 20) includes the following data dictionary views:

DBA_REPGROUP

GNAME MASTER STATUS SCHEMA_COMMENT
RS N NULL  

DBA_REPSITES

GNAME DBLINK MASTERDEF SNAPMASTER MASTER_COMMENT
RS M1 Y N  
RS M2 N Y  

DBA_REPOBJECT

GNAME ONAME TYPE STATUS OBJECT_COMMENT
RS EMPLOYEES SNAPSHOT VALID