User tables and data dictionary views are shown 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 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`
`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`
`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`

Master 1 (m1)

Master 2 (m2)

Materialized View 1 (department 10)

Materialized View 2 (department 20)

Master 1 (`m1`)

Master 2 (`m2`)