Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

18
DBMS_REPCAT

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

This chapter contains this topic:

Summary of DBMS_REPCAT Subprograms

Table 18-1 DBMS_REPCAT Package Subprograms  
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 Procedures"

Updates the comment field in the ALL_REPPRIORITY_GROUP view for a 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_SITE_PRIORITY Procedure"

Updates the comment field in the ALL_REPPRIORITY_GROUP view for a site priority group.

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

"STREAMS_MIGRATION Procedure"

Generates a migration script that migrates an Advanced Replication environment to a Streams environment.

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