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:
Master 1 and Master 2
Master 1 and Materialized View 1
Master 2 and Materialized View 2
Both master sites have a master group named rs, and both materialized view sites have a materialized view group named rs.
Master site 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 site 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 site 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 site 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 site 1 (department 90) includes the following materialized view:
employees
| employee_id | last_name | department_id | salary |
|---|---|---|---|
| 100 | King | 90 | 8340 |
| 101 | Kochhar | 90 | 6650 |
Materialized view employees is:
SELECT employee_id, last_name, department_id, salary FROM employees@m1 WHERE department_id = 90;
Materialized view site 1 (department 90) 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 site 2 (department 60) includes the following materialized view:
employees
| employee_id | last_name | department_id | salary |
|---|---|---|---|
| 103 | Hunold | 60 | 9725 |
| 104 | Ernst | 60 | 5890 |
Materialized view employees is:
SELECT employee_id, last_name, department_id, salary FROM employees@m1 WHERE department_id = 60;
Materialized view site 2 (department 60) 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 | - |