23
DBMS_REPCAT_RGT

DBMS_REPCAT_RGT controls the maintenance and definition of refresh group templates.

This chapter discusses the following topics:

• Summary of DBMS_REPCAT_RGT Subprograms

Summary of DBMS_REPCAT_RGT Subprograms

Table 23-1 DBMS_REPCAT_RGT Package Subprograms (Page 1 of 3)

Subprogram	Description
ALTER_REFRESH_TEMPLATE Procedure	Allows the DBA to alter existing deployment templates.
ALTER_TEMPLATE_OBJECT Procedure	Alters objects that have been added to a specified deployment template.
ALTER_TEMPLATE_PARM Procedure	Allows the DBA to alter the parameters for a specific deployment template.
ALTER_USER_AUTHORIZATION Procedure	Alters the contents of the DBA_REPCAT_USER_AUTHORIZATIONS view.
ALTER_USER_PARM_VALUE Procedure	Changes existing parameter values that have been defined for a specific user.
COMPARE_TEMPLATES Function	Allows the DBA to compare the contents of two deployment templates.
COPY_TEMPLATE Function	Allows the DBA to copy a deployment template.
CREATE_OBJECT_FROM_EXISTING Function	Creates a template object definition from existing database objects and adds it to a target deployment template.
CREATE_REFRESH_TEMPLATE Function	Creates the deployment template, which allows the DBA to define the template name, private/public status, and target refresh group.
CREATE_TEMPLATE_OBJECT Function	Adds object definitions to a target deployment template container.
CREATE_TEMPLATE_PARM Function	Creates parameters for a specific deployment template to allow custom data sets to be created at the remote materialized view site.
CREATE_USER_AUTHORIZATION Function	Authorizes specific users to instantiate private deployment templates.
CREATE_USER_PARM_VALUE Function	Predefines deployment template parameter values for specific users.
DELETE_RUNTIME_PARMS Procedure	Deletes a runtime parameter value that you defined using the INSERT_RUNTIME_PARMS procedure.
DROP_ALL_OBJECTS Procedure	Allows the DBA to drop all objects or specific object types from a deployment template.
DROP_ALL_TEMPLATE_PARMS Procedure	Allows the DBA to drop template parameters for a specified deployment template.
DROP_ALL_TEMPLATE_SITES Procedure	Removes all entries from the DBA_REPCAT_TEMPLATE_SITES view.
DROP_ALL_TEMPLATES Procedure	Removes all deployment templates at the site where the procedure is called.
DROP_ALL_USER_AUTHORIZATIONS Procedure	Allows the DBA to drop all user authorizations for a specified deployment template.
DROP_ALL_USER_PARM_VALUES Procedure	Drops user parameter values for a specific deployment template.
DROP_REFRESH_TEMPLATE Procedure	Drops a deployment template.
DROP_SITE_INSTANTIATION Procedure	Removes the target site from the DBA_REPCAT_TEMPLATE_SITES view.
DROP_TEMPLATE_OBJECT Procedure	Removes a template object from a specific deployment template.
DROP_TEMPLATE_PARM Procedure	Removes an existing template parameter from the DBA_REPCAT_TEMPLATE_PARMS view.
DROP_USER_AUTHORIZATION Procedure	Removes a user authorization entry from the DBA_REPCAT_USER_AUTHORIZATIONS view.
DROP_USER_PARM_VALUE Procedure	Removes a predefined user parameter value for a specific deployment template.
GET_RUNTIME_PARM_ID Function	Retrieves an identification to be used when defining a runtime parameter value.
INSERT_RUNTIME_PARMS Procedure	Defines runtime parameter values prior to instantiating a template.
INSTANTIATE_OFFLINE Function	Generates a script at the master site that is used to create the materialized view environment at the remote materialized view site while offline.
INSTANTIATE_ONLINE Function	Generates a script at the master site that is used to create the materialized view environment at the remote materialized view site while online.
LOCK_TEMPLATE_EXCLUSIVE Procedure	Prevents users from reading or instantiating the template when a deployment template is being updated or modified.
LOCK_TEMPLATE_SHARED Procedure	Makes a specified deployment template read-only.