20
DBMS_REPCAT

DBMS_REPCAT provides routines to administer and update the replication catalog and environment.

This chapter discusses the following topics:

• Summary of DBMS_REPCAT Subprograms

Summary of DBMS_REPCAT Subprograms

Table 20-1 DBMS_REPCAT Package Subprograms (Page 1 of 6)

Subprogram	Description
ADD_GROUPED_COLUMN Procedure	Adds members to an existing column group.
ADD_MASTER_DATABASE Procedure	Adds another master site to your replication environment.
ADD_NEW_MASTERS Procedure	Adds the master sites in the DBA_REPSITES_NEW data dictionary view to the replication catalog at all available master sites.
ADD_PRIORITY_datatype Procedure	Adds a member to a priority group.
ADD_SITE_PRIORITY_SITE Procedure	Adds a new site to a site priority group.
ADD_conflicttype_RESOLUTION Procedure	Designates a method for resolving an update, delete, or uniqueness conflict.
ALTER_CATCHUP_PARAMETERS Procedure	Alters the values for parameters stored in the DBA_REPEXTENSIONS data dictionary view.
ALTER_MASTER_PROPAGATION Procedure	Alters the propagation method for a specified replication group at a specified master site.
ALTER_MASTER_REPOBJECT Procedure	Alters an object in your replication environment.
ALTER_MVIEW_PROPAGATION Procedure	Alters the propagation method for a specified replication group at the current materialized view site.
ALTER_PRIORITY Procedure	Alters the priority level associated with a specified priority group member.
ALTER_PRIORITY_datatype Procedure	Alters the value of a member in a priority group.
ALTER_SITE_PRIORITY Procedure	Alters the priority level associated with a specified site.
ALTER_SITE_PRIORITY_SITE Procedure	Alters the site associated with a specified priority level.
CANCEL_STATISTICS Procedure	Stops collecting statistics about the successful resolution of update, uniqueness, and delete conflicts for a table.
COMMENT_ON_COLUMN_GROUP Procedure	Updates the comment field in the ALL_REPCOLUMN_GROUP view for a column group.
COMMENT_ON_conflicttype_RESOLUTION Procedure	Updates the SCHEMA_COMMENT field in the ALL_REPGROUP view for a materialized view site.
COMMENT_ON_PRIORITY_GROUP/COMMENT_ ON_SITE_PRIORITY Procedures	Updates the comment field in the ALL_REPPRIORITY_GROUP view for a (site) priority group.
COMMENT_ON_REPGROUP Procedure	Updates the comment field in the ALL_REPGROUP view for a master group.
COMMENT_ON_REPOBJECT Procedure	Updates the comment field in the ALL_REPOBJECT view for a replicated object.
COMMENT_ON_REPSITES Procedure	Updates the comment field in the ALL_REPSITE view for a replicated site.
COMMENT_ON_conflicttype_RESOLUTION Procedure	Updates the comment field in the ALL_REPRESOLUTION view for a conflict resolution routine.
COMPARE_OLD_VALUES Procedure	Specifies whether to compare old column values at each master site for each nonkey column of a replicated table for updates and deletes.
CREATE_MASTER_REPGROUP Procedure	Creates a new, empty, quiesced master group.
CREATE_MASTER_REPOBJECT Procedure	Specifies that an object is a replicated object.
CREATE_MVIEW_REPGROUP Procedure	Creates a new, empty materialized view group in your local database.
CREATE_MVIEW_REPOBJECT Procedure	Adds a replicated object to a materialized view group.
DEFINE_COLUMN_GROUP Procedure	Creates an empty column group.
DEFINE_PRIORITY_GROUP Procedure	Creates a new priority group for a master group.
DEFINE_SITE_PRIORITY Procedure	Creates a new site priority group for a master group.
DO_DEFERRED_REPCAT_ADMIN Procedure	Executes the local outstanding deferred administrative procedures for the specified master group at the current master site, or for all master sites.
DROP_COLUMN_GROUP Procedure	Drops a column group.
DROP_GROUPED_COLUMN Procedure	Removes members from a column group.
DROP_MASTER_REPGROUP Procedure	Drops a master group from your current site.
DROP_MASTER_REPOBJECT Procedure	Drops a replicated object from a master group.
DROP_PRIORITY Procedure	Drops a replicated object from a master group.
DROP_MVIEW_REPGROUP Procedure	Drops a materialized view site from your replication environment.
DROP_MVIEW_REPOBJECT Procedure	Drops a replicated object from a materialized view site.
DROP_PRIORITY Procedure	Drops a member of a priority group by priority level.
DROP_PRIORITY_GROUP Procedure	Drops a priority group for a specified master group.
DROP_PRIORITY_datatype Procedure	Drops a member of a priority group by value.
DROP_SITE_PRIORITY Procedure	Drops a site priority group for a specified master group.
DROP_SITE_PRIORITY_SITE Procedure	Drops a specified site, by name, from a site priority group.
DROP_conflicttype_RESOLUTION Procedure	Drops an update, delete, or uniqueness conflict resolution method.
EXECUTE_DDL Procedure	Supplies DDL that you want to have executed at each master site.
GENERATE_MVIEW_SUPPORT Procedure	Activates triggers and generate packages needed to support the replication of updatable materialized views or procedural replication.
GENERATE_REPLICATION_SUPPORT Procedure	Generates the triggers, packages, and procedures needed to support replication for a specified object.
MAKE_COLUMN_GROUP Procedure	Creates a new column group with one or more members.
PREPARE_INSTANTIATED_MASTER Procedure	Changes the global name of the database you are adding to a master group.
PURGE_MASTER_LOG Procedure	Removes local messages in the DBA_REPCATLOG associated with a specified identification number, source, or master group.
PURGE_STATISTICS Procedure	Removes information from the ALL_REPRESOLUTION_STATISTICS view.
REFRESH_MVIEW_REPGROUP Procedure	Refreshes a materialized view group with the most recent data from its associated master site or master materialized view site.
REGISTER_MVIEW_REPGROUP Procedure	Facilitates the administration of materialized views at their respective master sites or master materialized view sites by inserting, modifying, or deleting from DBA_REGISTERED_MVIEW_GROUPS.
REGISTER_STATISTICS Procedure	Collects information about the successful resolution of update, delete, and uniqueness conflicts for a table.
RELOCATE_MASTERDEF Procedure	Changes your master definition site to another master site in your replication environment.
REMOVE_MASTER_DATABASES Procedure	Removes one or more master databases from a replication environment.
RENAME_SHADOW_COLUMN_GROUP Procedure	Renames the shadow column group of a replicated table to make it a named column group.
REPCAT_IMPORT_CHECK Procedure	Ensures that the objects in the master group have the appropriate object identifiers and status values after you perform an export/import of a replicated object or an object used by the advanced replication facility.
RESUME_MASTER_ACTIVITY Procedure	Resumes normal replication activity after quiescing a replication environment.
RESUME_PROPAGATION_TO_MDEF Procedure	Indicates that export is effectively finished and propagation for both extended and unaffected replication groups existing at master sites can be enabled.
SEND_OLD_VALUES Procedure	Specifies whether to send old column values for each nonkey column of a replicated table for updates and deletes.
SET_COLUMNS Procedure	Specifies use of an alternate column or group of columns, instead of the primary key, to determine which columns of a table to compare when using row-level replication.
SPECIFY_NEW_MASTERS Procedure	Specifies the master sites you intend to add to an existing replication group without quiescing the group.
SUSPEND_MASTER_ACTIVITY Procedure	Suspends replication activity for a master group.
SWITCH_MVIEW_MASTER Procedure	Changes the master site of a materialized view group to another master site.
UNDO_ADD_NEW_MASTERS_REQUEST Procedure	Undoes all of the changes made by the SPECIFY_NEW_MASTERS and ADD_NEW_MASTERS procedures for a specified extension_id.
UNREGISTER_MVIEW_REPGROUP Procedure	Facilitates the administration of materialized views at their respective master sites and master materialized view sites by inserting, modifying, or deleting from DBA_REGISTERED_MVIEW_GROUPS.
VALIDATE Function	Validates the correctness of key conditions of a multimaster replication environment.
WAIT_MASTER_LOG Procedure	Determines whether changes that were asynchronously propagated to a master site have been applied.