Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REPCAT, 65 of 69
This procedure changes the master site of a materialized view group to another master site. This procedure does a full refresh of the affected materialized views and regenerates the triggers and their associated packages as needed. This procedure does not push the queue to the old master site before changing master sites.
If min_communication
is true
for the materialized view and the new master site is an Oracle7 master site, then regenerate replication support for the materialized view with min_communication
set to false
.
If generate_80_compatible
is false
for the materialized view and the new master site is a release lower than Oracle8i (Oracle7 or Oracle8), then regenerate replication support for the materialized view with generate_80_compatible
set to true
.
You can set both parameters for a materialized view in one call to DBMS_REPCAT.GENERATE_MVIEW_SUPPORT
.
DBMS_REPCAT.SWITCH_MVIEW_MASTER ( gname IN VARCHAR2, master IN VARCHAR2 gowner IN VARCHAR2 := 'PUBLIC');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|