eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_REPCAT_TEMPLATE_SITES

Object Details

Object Name:	DBA_REPCAT_TEMPLATE_SITES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REFRESH_TEMPLATE_NAME	VARCHAR2	(30)	Yes	Name of the refresh group template.
REFRESH_GROUP_NAME	VARCHAR2	(30)		Name of the refresh group to create during instantiation.
TEMPLATE_OWNER	VARCHAR2	(128)		Owner of the refresh group template.
USER_NAME	VARCHAR2	(128)	Yes	Database user name.
SITE_NAME	VARCHAR2	(128)		Name of the site that has instantiated the template.
REPAPI_SITE_NAME	VARCHAR2	(128)		Name of the repapi site that has instantiated the template.
STATUS	VARCHAR2	(10)		Status of the instantiation at the site.
INSTANTIATION_DATE	DATE			Date template was instantiated.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REFRESH_TEMPLATE_NAME
,      REFRESH_GROUP_NAME
,      TEMPLATE_OWNER
,      USER_NAME
,      SITE_NAME
,      REPAPI_SITE_NAME
,      STATUS
,      INSTANTIATION_DATE
FROM SYS.DBA_REPCAT_TEMPLATE_SITES;

Dependencies

[top of page]

SYS.DBA_REPCAT_TEMPLATE_SITES references the following:

SYS: SNAP_SITE$
SYSTEM: REPCAT$_TEMPLATE_SITES

SYS.DBA_REPCAT_TEMPLATE_SITES is referenced by following:

PUBLIC: DBA_REPCAT_TEMPLATE_SITES