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

TABLE: SYSTEM.REPCAT$_TEMPLATE_REFGROUPS

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

Table for maintaining refresh group information for template.

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_TEMPLATE_REFGROUPS_PK
  1. ColumnREFRESH_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_TEMPLATE_REFGROUPS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnREFRESH_GROUP_ID
REPCAT$_TEMPLATE_REFGROUPS_N1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnREFRESH_GROUP_NAME
REPCAT$_TEMPLATE_REFGROUPS_N2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnREFRESH_TEMPLATE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_TEMPLATE_REFGROUPS REPCAT$_TEMPLATE_REFGROUPS_FK1 TableREPCAT$_REFRESH_TEMPLATES REPCAT$_TEMPLATE_REFGROUPS REFRESH_TEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
REFRESH_GROUP_ID NUMBER
Yes Internal primary key of the refresh groups table.
REFRESH_GROUP_NAME VARCHAR2 (30) Yes Name of the refresh group
REFRESH_TEMPLATE_ID NUMBER
Yes Primary key of the template containing the refresh group.
ROLLBACK_SEG VARCHAR2 (30)
Name of the rollback segment to use during refresh.
START_DATE VARCHAR2 (200)
Refresh start date.
INTERVAL VARCHAR2 (200)
Refresh interval.
Query Text

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


SELECT REFRESH_GROUP_ID
,      REFRESH_GROUP_NAME
,      REFRESH_TEMPLATE_ID
,      ROLLBACK_SEG
,      START_DATE
,      INTERVAL
FROM SYSTEM.REPCAT$_TEMPLATE_REFGROUPS;

Dependencies

[top of page]

SYSTEM.REPCAT$_TEMPLATE_REFGROUPS does not reference any database object

SYSTEM.REPCAT$_TEMPLATE_REFGROUPS is referenced by following:

SchemaSYS
ViewDBA_TEMPLATE_REFGROUPS