[Home] [Help] [Dependency Information]
Object Name: | REPCAT$_REFRESH_TEMPLATES |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Primary table containing deployment template information.
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
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 |
---|
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. |
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;
SYSTEM.REPCAT$_REFRESH_TEMPLATES does not reference any database object
SYSTEM.REPCAT$_REFRESH_TEMPLATES is referenced by following:
|
|
|