Oracle9i Replication Management API Reference Release 1 (9.0.1) Part Number A87502-01 |
|
DBMS_REPCAT
provides routines to administer and update the replication catalog and environment.
This chapter discusses the following topics:
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 |
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 |
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 |
COMMENT_ON_conflicttype_RESOLUTION Procedure |
Updates the |
COMMENT_ON_PRIORITY_GROUP/COMMENT_ ON_SITE_PRIORITY Procedures |
Updates the comment field in the |
COMMENT_ON_REPGROUP Procedure |
Updates the comment field in the |
COMMENT_ON_REPOBJECT Procedure |
Updates the comment field in the |
COMMENT_ON_REPSITES Procedure |
Updates the comment field in the |
COMMENT_ON_conflicttype_RESOLUTION Procedure |
Updates the comment field in the |
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 |
PURGE_STATISTICS Procedure |
Removes information from the |
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 |
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 |
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 |
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. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|