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

CREATE_REFRESH_TEMPLATE Function

This function creates the deployment template, which enables you to define the template name, private/public status, and target refresh group. Each time that you create a template object, user authorization, or template parameter, you reference the deployment template created with this function. This function adds a row to the DBA_REPCAT_REFRESH_TEMPLATES view. The number returned by this function is used internally by Oracle to manage deployment templates.

Syntax

DBMS_REPCAT_RGT.CREATE_REFRESH_TEMPLATE (
   owner                  IN   VARCHAR2, 
   refresh_group_name     IN   VARCHAR2, 
   refresh_template_name  IN   VARCHAR2, 
   template_comment       IN   VARCHAR2 := NULL,
   public_template        IN   VARCHAR2 := NULL,
   last_modified          IN   DATE := SYSDATE,
   modified_by            IN   VARCHAR2 := USER,
   creation_date          IN   DATE := SYSDATE,
   created_by             IN   VARCHAR2 := USER)
  return NUMBER;

Parameters

Table 21-21 CREATE_REFRESH_TEMPLATE Function Parameters  
Parameter Description
owner

User name of the deployment template owner is specified with this parameter. If an owner is not specified, then the name of the user creating the template is automatically used.

refresh_group_name

Name of the refresh group that is created when this template is instantiated. All objects created by this template are assigned to the specified refresh group.

refresh_template_name

Name of the deployment template that you are creating. This name is referenced in all activities that involve this deployment template.

template_comment

User comments defined with this parameter are listed in the DBA_REPCAT_REFRESH_TEMPLATES view.

public_template

Specifies whether the deployment template is public or private. Only acceptable values are 'Y' and 'N' ('Y' = public and 'N' = private).

last_modified

The date of the last modification made to this deployment template. If a value is not specified, then the current date is automatically used.

modified_by

Name of the user who last modified this deployment template. If a value is not specified, then the current user is automatically used.

creation_date

The date that this deployment template was created. If a value is not specified, then the current date is automatically used.

created_by

Name of the user who created this deployment template. If a value is not specified, then the current user is automatically used.

Exceptions

Table 21-22 CREATE_REFRESH_TEMPLATE Function Exceptions  
Exception Description
dupl_refresh_template

A template with the specified name already exists. See the ALL_REPCAT_REFRESH_TEMPLATES view to see a list of existing templates.

bad_public_template

The public_template parameter is specified incorrectly. The public_template parameter must be specified as a 'Y' for a public template or an 'N' for a private template.

Returns

Table 21-23 CREATE_REFRESH_TEMPLATE Function Returns
Return Value Description
<system-generated 
number>

System-generated number used internally by Oracle.