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