Oracle8i Replication Management API Reference
Release 2 (8.1.6)

Part Number A76958-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Replication Management API Reference, 52 of 179


DBMS_REPCAT Package

Summary of Subprograms

Table 8-81 DBMS_REPCAT Package Subprograms (Page 1 of 5)
Subprogram  Description 
ADD_GROUPED_COLUMN 
procedure
 

Adds members to an existing column group. 

ADD_MASTER_DATABASE 
procedure
 

Adds another master site to your replicated environment.  

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_MASTER_PROPAGATION 
procedure
 

Alters the propagation method for a specified object group at a specified master site. 

ALTER_MASTER_REPOBJECT 
procedure
 

Alters an object in your replicated environment. 

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. 

ALTER_SNAPSHOT_PROPAGATION 
procedure
 

Alters the propagation method for a specified object group at the current snapshot site. 

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_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 replicated 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_SNAPSHOT_
REPSITES procedure
 

Updates the SCHEMA_COMMENT field in the ALL_REPGROUP view for a snapshot site. 

COMMENT_ON_conflicttype_
RESOLUTION procedure
 

Updates the comment field in the ALL_REPRESOLUTION view for a conflict resolution routine. 

COMPARE_OLD_VALUES 
procedure
 

Compares old column values at each master site for each non-key column of a replicated table for updates and deletes.  

CREATE_MASTER_REPGROUP 
procedure
 

Creates a new, empty, quiesced master replication object group. 

CREATE_MASTER_REPOBJECT 
procedure
 

Indicates that an object is a replicated object. 

CREATE_SNAPSHOT_REPGROUP 
procedure
 

Creates a new, empty snapshot replication object group in your local database.  

CREATE_SNAPSHOT_REPOBJECT 
procedure
 

Adds a replicated object to your snapshot site.  

DEFINE_COLUMN_GROUP 
procedure
 

Creates an empty column group 

DEFINE_PRIORITY_GROUP 
procedure
 

Creates a new priority group for a replicated master group.  

DEFINE_SITE_PRIORITY 
procedure
 

Creates a new site priority group for a replicated master group.  

DO_DEFERRED_REPCAT_ADMIN 
procedure
 

Executes the local outstanding deferred administrative procedures for the specified replicated 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 replicated master group from your current site. 

DROP_MASTER_REPOBJECT 
procedure
 

Drops a replicated object from a replicated master group. 

DROP_PRIORITY procedure
 

Drops a member of a priority group by priority level. 

DROP_PRIORITY_GROUP 
procedure
 

Drops a priority group for a specified replicated 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 replicated master group.  

DROP_SITE_PRIORITY_SITE 
procedure
 

Drops a specified site, by name, from a site priority group.  

DROP_SNAPSHOT_REPGROUP 
procedure
 

Drops a snapshot site from your replicated environment. 

DROP_SNAPSHOT_REPOBJECT 
procedure
 

Drops a replicated object from a snapshot site.  

DROP_conflicttype_
RESOLUTION procedure
 

Drops an update, delete, or uniqueness conflict resolution routine.  

EXECUTE_DDL procedure
 

Supplies DDL that you want to have executed at each master site. 

GENERATE_REPLICATION_
SUPPORT procedure
 

Generates the triggers, packages, and procedures needed to support replication.  

GENERATE_SNAPSHOT_SUPPORT 
procedure
 

Activates triggers and generate packages needed to support the replication of updatable snapshots or procedural replication. 

MAKE_COLUMN_GROUP procedure
 

Creates a new column group with one or more members.  

PURGE_MASTER_LOG procedure
 

Removes local messages in the RepCatLog associated with a specified identification number, source, or replicated master group. 

PURGE_STATISTICS procedure
 

Removes information from the ALL_REPRESOLUTION_STATISTICS view. 

REFRESH_SNAPSHOT_REPGROUP 
procedure
 

Refreshes a snapshot site object group with the most recent data from its associated master site.  

REGISTER_SNAPSHOT_REPGROUP 
procedure
 

Facilitates the administration of snapshots at their respective master sites by inserting, modifying, or deleting from DBA_REGISTERED_SNAPSHOT_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 replicated environment. 

REMOVE_MASTER_DATABASES 
procedure
 

Removes one or more master databases from a replicated environment.  

REPCAT_IMPORT_CHECK 
procedure
 

Ensures that the objects in the replicated 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 replicated environment. 

SEND_OLD_VALUES procedure
 

Specifies whether to send old column values for each non-key column of a replicated table for updates and deletes. 

SET_COLUMNS procedure
 

Specifies use 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. 

SUSPEND_MASTER_ACTIVITY 
procedure
 

Suspends replication activity for an object group. 

SWITCH_SNAPSHOT_MASTER 
procedure
 

Changes the master database of a snapshot replicated master group to another master site.  

UNREGISTER_SNAPSHOT_
REPGROUP procedure
 

Facilitates the administration of snapshots at their respective master sites by inserting, modifying, or deleting from repcat$_repsite

VALIDATE function
 

Validates the correctness of key conditions of a multiple master replication environment.  

WAIT_MASTER_LOG procedure
 

Determines whether changes that were asynchronously propagated to a master site have been applied. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index