In Oracle, the static dictionary view USER_REPCAT_TEMPLATE_SITES maintains the information of the template instances current status in an enterprise network. The structure of the dictionary view is shown below.
refresh_template_name [VARCHAR2(30)]- Deployment template name
refresh_group_name [VARCHAR2(30)]- Refresh group associated during the instantiation process.
template_owner [VARCHAR2(30)]- Deployment template owner
user_name [VARCHAR2(30)]- User instantiating the deployment template
site_name [VARCHAR2(128)]- Deployment templates target materialized view
repapi_site_name [VARCHAR2(128)]- Column to be used in further releases of database
status [VARCHAR2(10)]- Status of the deployment template (0 = Not Installed,1 = Installed, -1 = Installed with errors )
instantiation_date [DATE]- The date when the template was instantiated