ALL_REPCAT_REFRESH_TEMPLATES

Contains global information about each deployment template accessible to the current user, such as the template name, template owner, what refresh group the template objects belong to, and the type of template (private or public).

When the DBA adds materialized view definitions to the template container, the DBA references the appropriate REFRESH_TEMPLATE_NAME. Any materialized views added to a specific template are added to the refresh group specified in REFRESH_GROUP_NAME.

Furthermore, deployment templates created as public are available to all users who can connect to the master site. Deployment templates created as private are limited to those users listed in the ALL_REPCAT_USER_AUTHORIZATIONS view.

Related Views:

• DBA_REPCAT_REFRESH_TEMPLATES describes all deployment templates in the database.
• USER_REPCAT_REFRESH_TEMPLATES describes all deployment templates owned by the current user.

  Column	Datatype	NULL	Description
  REFRESH_TEMPLATE_NAME	VARCHAR2(30)	-	Name of the deployment template.
  OWNER	VARCHAR2(30)	-	Owner of the deployment template.
  REFRESH_GROUP_NAME	VARCHAR2(30)	-	Name of the refresh group to which the template objects are added during the instantiation process.
  TEMPLATE_COMMENT	VARCHAR2(2000)	-	User supplied comment.
  PUBLIC_TEMPLATE	VARCHAR2(1)	-	If Y then the deployment template is public. If N then the deployment template is private.