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

21
DBMS_REPCAT_RGT

DBMS_REPCAT_RGT controls the maintenance and definition of refresh group templates.

This chapter contains this topic:

Summary of DBMS_REPCAT_RGT Subprograms

Table 21-1 DBMS_REPCAT_RGT Package Subprograms  
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.