Oracle9i Replication Management API Reference Release 1 (9.0.1) Part Number A87502-01 |
|
DBMS_REPCAT_RGT
controls the maintenance and definition of refresh group templates.
This chapter discusses the following topics:
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 |
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 |
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 |
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 |
DROP_TEMPLATE_OBJECT Procedure |
Removes a template object from a specific deployment template. |
DROP_TEMPLATE_PARM Procedure |
Removes an existing template parameter from the |
DROP_USER_AUTHORIZATION Procedure |
Removes a user authorization entry from the |
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. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|