[Home] [Help] [Dependency Information]
Object Name: | REPCAT$_TEMPLATE_SITES |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
Table | |
Foreign Table | Foreign Key Column | REPCAT$_SITE_OBJECTS | REPCAT$_TEMPLATE_SITES | REPCAT$_SITE_OBJECTS TEMPLATE_SITE_ID |
---|
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. |
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;
SYSTEM.REPCAT$_TEMPLATE_SITES does not reference any database object
SYSTEM.REPCAT$_TEMPLATE_SITES is referenced by following:
|
|
|