Viewing the Materialized Views for a Master Site

When you configure a materialized view at a materialized view site, it registers the materialized view at the master site. You can query the ALL_REGISTERED_MVIEWS data dictionary view to show the following information about each materialized view registered at a master site:

• The owner of the materialized view

• The name of the materialized view

• The materialized view site that contains the materialized view

• Whether the materialized view is updatable or read-only

To show this information: 

1. Open SQL*Plus and connect to the master site as an administrative user, such as the replication administrator or SYSTEM. By default, the user name of the replication administrator is repadmin.

   See Starting SQL*Plus and Connecting to the Database for more information about starting SQL*Plus.

2. Run the following query:

   COLUMN OWNER HEADING 'Owner' FORMAT A20
   COLUMN NAME HEADING 'Name' FORMAT A20
   COLUMN MVIEW_SITE HEADING 'Materialized|View Site' FORMAT A15
   COLUMN UPDATABLE HEADING 'Updatable?' FORMAT A10
    
   SELECT OWNER, NAME, MVIEW_SITE, UPDATABLE
     FROM ALL_REGISTERED_MVIEWS;
   

   The output will be similar to the following:

                                             Materialize               
   Owner                Name                 View Site       Updatable?
   -------------------- -------------------- --------------- ----------
   HR                   COUNTRIES_MV         II2.EXAMPLE.COM YES
   HR                   DEPARTMENTS_MV       II2.EXAMPLE.COM YES
   HR                   EMPLOYEES_MV         II2.EXAMPLE.COM YES
   HR                   JOBS_MV              II2.EXAMPLE.COM YES
   HR                   JOB_HISTORY_MV       II2.EXAMPLE.COM YES
   HR                   LOCATIONS_MV         II2.EXAMPLE.COM YES
   HR                   REGIONS_MV           II2.EXAMPLE.COM YES