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]

TABLE: SYSTEM.REPCAT$_TEMPLATE_SITES

Object Details

Object Name:	REPCAT$_TEMPLATE_SITES
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_TEMPLATE_SITES_PK

TEMPLATE_SITE_ID

Unique Key: REPCAT$_TEMPLATE_SITES_U1

REFRESH_TEMPLATE_NAME
USER_NAME
SITE_NAME
REPAPI_SITE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_TEMPLATE_SITES_PK	NORMAL	UNIQUE	SYSTEM	TEMPLATE_SITE_ID
REPCAT$_TEMPLATE_SITES_U1	NORMAL	UNIQUE	SYSTEM	REFRESH_TEMPLATE_NAME USER_NAME SITE_NAME REPAPI_SITE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_SITE_OBJECTS		REPCAT$_TEMPLATE_SITES	REPCAT$_SITE_OBJECTS TEMPLATE_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_SITE_ID	NUMBER		Yes	Internal primary key of the REPCAT$_TEMPLATE_SITES table.
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_ID	NUMBER			Name of the site that has instantiated the template.
STATUS	NUMBER		Yes	Obsolete - do not use.
REFRESH_TEMPLATE_ID	NUMBER			Obsolete - do not use.
USER_ID	NUMBER			Obsolete - do not use.
INSTANTIATION_DATE	DATE			Date template was instantiated.

Query Text

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


SELECT TEMPLATE_SITE_ID
,      REFRESH_TEMPLATE_NAME
,      REFRESH_GROUP_NAME
,      TEMPLATE_OWNER
,      USER_NAME
,      SITE_NAME
,      REPAPI_SITE_ID
,      STATUS
,      REFRESH_TEMPLATE_ID
,      USER_ID
,      INSTANTIATION_DATE
FROM SYSTEM.REPCAT$_TEMPLATE_SITES;

Dependencies

[top of page]

SYSTEM.REPCAT$_TEMPLATE_SITES does not reference any database object

SYSTEM.REPCAT$_TEMPLATE_SITES is referenced by following:

SYS: ALL_REPCAT_TEMPLATE_SITES; DBA_IAS_SITES; DBA_REPCAT_TEMPLATE_SITES; DBMS_REPCAT_RGT_CHK - show dependent code; DBMS_REPCAT_RGT_CUST - show dependent code; DBMS_REPCAT_RGT_CUST2 - show dependent code; DBMS_REPCAT_RGT_EXP - show dependent code; DBMS_REPCAT_RGT_UTL - show dependent code; USER_REPCAT_TEMPLATE_SITES