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$_REFRESH_TEMPLATES

Object Details

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

Primary table containing deployment template information.

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_REFRESH_TEMPLATES_PK

REFRESH_TEMPLATE_ID

Unique Key: REPCAT$_REFRESH_TEMPLATES_U1

REFRESH_TEMPLATE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_REFRESH_TEMPLATES_PK	NORMAL	UNIQUE	SYSTEM	REFRESH_TEMPLATE_ID
REPCAT$_REFRESH_TEMPLATES_U1	NORMAL	UNIQUE	SYSTEM	REFRESH_TEMPLATE_NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
REPCAT$_REFRESH_TEMPLATES	REPCAT$_TEMPLATE_STATUS	REPCAT$_REFRESH_TEMPLATES TEMPLATE_STATUS_ID
REPCAT$_REFRESH_TEMPLATES	REPCAT$_TEMPLATE_TYPES	REPCAT$_REFRESH_TEMPLATES TEMPLATE_TYPE_ID
REPCAT$_INSTANTIATION_DDL	REPCAT$_REFRESH_TEMPLATES	REPCAT$_INSTANTIATION_DDL REFRESH_TEMPLATE_ID
REPCAT$_TEMPLATE_OBJECTS	REPCAT$_REFRESH_TEMPLATES	REPCAT$_TEMPLATE_OBJECTS REFRESH_TEMPLATE_ID
REPCAT$_TEMPLATE_PARMS	REPCAT$_REFRESH_TEMPLATES	REPCAT$_TEMPLATE_PARMS REFRESH_TEMPLATE_ID
REPCAT$_TEMPLATE_REFGROUPS	REPCAT$_REFRESH_TEMPLATES	REPCAT$_TEMPLATE_REFGROUPS REFRESH_TEMPLATE_ID
REPCAT$_USER_AUTHORIZATIONS	REPCAT$_REFRESH_TEMPLATES	REPCAT$_USER_AUTHORIZATIONS REFRESH_TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REFRESH_TEMPLATE_ID	NUMBER		Yes	Internal primary key of the REPCAT$_REFRESH_TEMPLATES table.
OWNER	VARCHAR2	(128)	Yes	Owner of the refresh group template.
REFRESH_GROUP_NAME	VARCHAR2	(30)	Yes	Name of the refresh group to create during instantiation.
REFRESH_TEMPLATE_NAME	VARCHAR2	(30)	Yes	Name of the refresh group template.
TEMPLATE_COMMENT	VARCHAR2	(2000)		Optional comment field for the refresh group template.
PUBLIC_TEMPLATE	VARCHAR2	(1)		Flag specifying public template or private template.
LAST_MODIFIED	DATE			Date the row was last modified.
MODIFIED_BY	NUMBER			User id of the user that modified the row.
CREATION_DATE	DATE			Date the row was created.
CREATED_BY	NUMBER			User id of the user that created the row.
REFRESH_GROUP_ID	NUMBER		Yes	Internal primary key to default refresh group for the template.
TEMPLATE_TYPE_ID	NUMBER		Yes	Internal primary key to the template types.
TEMPLATE_STATUS_ID	NUMBER		Yes	Internal primary key to the template status table.
FLAGS	RAW	(255)		Internal flags for the template.
SPARE1	VARCHAR2	(4000)		Reserved for future use.

Query Text

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


SELECT REFRESH_TEMPLATE_ID
,      OWNER
,      REFRESH_GROUP_NAME
,      REFRESH_TEMPLATE_NAME
,      TEMPLATE_COMMENT
,      PUBLIC_TEMPLATE
,      LAST_MODIFIED
,      MODIFIED_BY
,      CREATION_DATE
,      CREATED_BY
,      REFRESH_GROUP_ID
,      TEMPLATE_TYPE_ID
,      TEMPLATE_STATUS_ID
,      FLAGS
,      SPARE1
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES;

Dependencies

[top of page]

SYSTEM.REPCAT$_REFRESH_TEMPLATES does not reference any database object

SYSTEM.REPCAT$_REFRESH_TEMPLATES is referenced by following:

SYS: ALL_REPCAT_REFRESH_TEMPLATES; ALL_REPCAT_TEMPLATE_OBJECTS; ALL_REPCAT_TEMPLATE_PARMS; ALL_REPCAT_TEMPLATE_SITES; ALL_REPCAT_USER_AUTHORIZATIONS; ALL_REPCAT_USER_PARM_VALUES; DBA_IAS_GEN_STMTS; DBA_IAS_OBJECTS_BASE; DBA_IAS_OBJECTS_EXP; DBA_IAS_TEMPLATES; DBA_REPCAT_REFRESH_TEMPLATES; DBA_REPCAT_TEMPLATE_OBJECTS; DBA_REPCAT_TEMPLATE_PARMS; DBA_REPCAT_USER_AUTHORIZATIONS; DBA_REPCAT_USER_PARM_VALUES; DBA_TEMPLATE_REFGROUPS; DBMS_REPCAT_RGT_ALT - show dependent code; DBMS_REPCAT_RGT_CHK - show dependent code; DBMS_REPCAT_RGT_CUST - show dependent code; DBMS_REPCAT_RGT_UTL - show dependent code; USER_REPCAT_REFRESH_TEMPLATES; USER_REPCAT_TEMPLATE_OBJECTS; USER_REPCAT_TEMPLATE_PARMS; USER_REPCAT_TEMPLATE_SITES; USER_REPCAT_USER_AUTHORIZATION; USER_REPCAT_USER_PARM_VALUES