This illustration 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 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 -

Oracle
Copyright © 1996, 2013, Oracle and/or its affiliates. All rights reserved.
Legal Notices