Data Dictionary Views, 7 of 112

ALL_REPCAT_TEMPLATE_SITES

Contains information about the current status of template instantiation among the sites of an enterprise network. This view contains information about instantiation sites for deployment templates that are accessible to the current user. Specifically, the DBA can monitor the installation and deletion of templates at specific sites, including RepAPI sites.

Related views:

DBA_REPCAT_TEMPLATE_SITES describes all remote instantiation sites for all templates in the database.

USER_REPCAT_TEMPLATE_SITES describes remote instantiation sites for all templates owned by the current user.

Column Datatype NULL Description

REFRESH_TEMPLATE_NAME

VARCHAR2(30)

NOT NULL

Name of the deployment template.

REFRESH_GROUP_NAME

VARCHAR2(30)

Name of the refresh group to which template objects are added during the instantiation process.

TEMPLATE_OWNER

VARCHAR2(30)

Name of the user who is considered the owner of the deployment template.

USER_NAME

VARCHAR2(30)

NOT NULL

The name of the user who instantiated the deployment template.

SITE_NAME

VARCHAR2(128)

Target snapshot site of the deployment template. This field is NULL for RepAPI sites.

REPAPI_SITE_NAME

VARCHAR2(128)

The ID of the RepAPI site that has instantiated the displayed deployment template. This field is NULL for non-RepAPI clients.

STATUS

VARCHAR2(10)

Displays the status of the deployment template at the target snapshot site:
0 = Not Installed
1 = Installed
-1 = Installed with errors

Column	Datatype	NULL	Description
`REFRESH_TEMPLATE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the deployment template.
`REFRESH_GROUP_NAME`	`VARCHAR2(30)`		Name of the refresh group to which template objects are added during the instantiation process.
`TEMPLATE_OWNER`	`VARCHAR2(30)`		Name of the user who is considered the owner of the deployment template.
`USER_NAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the user who instantiated the deployment template.
`SITE_NAME`	`VARCHAR2(128)`		Target snapshot site of the deployment template. This field is NULL for RepAPI sites.
`REPAPI_SITE_NAME`	`VARCHAR2(128)`		The ID of the RepAPI site that has instantiated the displayed deployment template. This field is NULL for non-RepAPI clients.
`STATUS`	`VARCHAR2(10)`		Displays the status of the deployment template at the target snapshot site: 0 = Not Installed 1 = Installed -1 = Installed with errors