48
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 48-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.