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 current chapter
Up
Go to next page
Next
View PDF

COPY_TEMPLATE Function

This function enables you to copy a deployment template and is helpful when a new deployment template uses many of the objects contained in an existing deployment template. This function copies the deployment template, template objects, template parameters, and user parameter values. The DBA can optionally have the function copy the user authorizations for this template. The number returned by this function is used internally by Oracle to manage deployment templates.


Note:

The values in the DBA_REPCAT_TEMPLATE_SITES view are not copied.


This function also allows the DBA to copy a deployment template to another master site, which is helpful for deployment template distribution and to split network loads between multiple sites.

Syntax

DBMS_REPCAT_RGT.COPY_TEMPLATE (
   old_refresh_template_name     IN   VARCHAR2, 
   new_refresh_template_name     IN   VARCHAR2,
   copy_user_authorizations      IN   VARCHAR2,
   dblink                        IN   VARCHAR2 := NULL)
  return NUMBER;

Parameters

Table 21-15 COPY_TEMPLATE Function Parameters  
Parameter Description
old_refresh_template_name

Name of the deployment template to be copied.

new_refresh_template_name

Name of the new deployment template.

copy_user_authorizations

Specifies whether the template authorizations for the original template should be copied for the new deployment template. Valid values for this parameter are Y, N, and NULL.

Note: All users must exist at the target database.

dblink

Optionally defines where the deployment template should be copied from (this is helpful to distribute deployment templates to other master sites). If none is specified, then the deployment template is copied from the local master site.

Exceptions

Table 21-16 COPY_TEMPLATE Function Exceptions  
Exception Description
miss_refresh_template

Deployment template name to be copied is invalid or does not exist.

dupl_refresh_template

Name of the new refresh template specified already exists.

bad_copy_auth

Value specified for the copy_user_authorization parameter is invalid. Valid values are Y, N, and NULL.

Returns

Table 21-17 COPY_TEMPLATES Function Returns
Return Value Description

<system-generated number>

System-generated number used internally by Oracle.