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.

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 materialized view site of the deployment template.
  REPAPI_SITE_NAME	VARCHAR2(128)		This column is intended for use in a future release of Oracle.
  STATUS	VARCHAR2(10)		Displays the status of the deployment template at the target materialized view site: 0 = Not Installed 1 = Installed -1 = Installed with errors
  INSTANTIATION_DATE	DATE		Displays when the template was instantiated. Is NULL if the template has not yet been instantiated.