[Home] [Help] [Dependency Information]
Object Name: | REPCAT$_TEMPLATE_OBJECTS |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
REPCAT$_TEMPLATE_OBJECTS_PK | NORMAL | UNIQUE | SYSTEM | TEMPLATE_OBJECT_ID |
REPCAT$_TEMPLATE_OBJECTS_U1 | NORMAL | UNIQUE | SYSTEM |
OBJECT_NAME
OBJECT_TYPE REFRESH_TEMPLATE_ID SCHEMA_NAME DDL_NUM |
SYS_IL0000003265C00005$$ | LOB | UNIQUE | SYSTEM | |
REPCAT$_TEMPLATE_OBJECTS_N1 | NORMAL | NONUNIQUE | SYSTEM |
REFRESH_TEMPLATE_ID
OBJECT_TYPE |
REPCAT$_TEMPLATE_OBJECTS_N2 | NORMAL | NONUNIQUE | SYSTEM |
REFRESH_TEMPLATE_ID
OBJECT_TYPE MASTER_ROLLBACK_SEG |
REPCAT$_TEMPLATE_OBJECTS_N3 | NORMAL | NONUNIQUE | SYSTEM |
REFRESH_TEMPLATE_ID
OBJECT_NAME MASTER_ROLLBACK_SEG OBJECT_TYPE |
Table | |
Foreign Table | Foreign Key Column | REPCAT$_TEMPLATE_OBJECTS | REPCAT$_OBJECT_TYPES | REPCAT$_TEMPLATE_OBJECTS OBJECT_TYPE | REPCAT$_TEMPLATE_OBJECTS | REPCAT$_REFRESH_TEMPLATES | REPCAT$_TEMPLATE_OBJECTS REFRESH_TEMPLATE_ID | REPCAT$_OBJECT_PARMS | REPCAT$_TEMPLATE_OBJECTS | REPCAT$_OBJECT_PARMS TEMPLATE_OBJECT_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_OBJECT_ID | NUMBER | Yes | Internal primary key of the REPCAT$_TEMPLATE_OBJECTS table. | |
REFRESH_TEMPLATE_ID | NUMBER | Yes | Internal primary key of the REPCAT$_REFRESH_TEMPLATES table. | |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the database object. |
OBJECT_TYPE | NUMBER | Yes | Type of database object. | |
DDL_TEXT | CLOB | (4000) | DDL string for creating the object or WHERE clause for snapshot query. | |
MASTER_ROLLBACK_SEG | VARCHAR2 | (30) | Rollback segment for use during snapshot refreshes. | |
DERIVED_FROM_SNAME | VARCHAR2 | (128) | Schema name of schema containing object this was derived from. | |
DERIVED_FROM_ONAME | VARCHAR2 | (128) | Object name of object this object was derived from. | |
FLAVOR_ID | NUMBER | Foreign key to the REPCAT$_FLAVORS table. | ||
DDL_NUM | NUMBER | Order of ddls to execute. | ||
SCHEMA_NAME | VARCHAR2 | (128) | Schema containing the object. | |
OBJECT_VERSION# | NUMBER | Version# of database object of TYPE. | ||
TEMPLATE_REFGROUP_ID | NUMBER | Yes | Internal ID of the refresh group to contain the object. | |
FLAGS | RAW | (255) | Internal flags for the object. | |
SPARE1 | VARCHAR2 | (4000) | Reserved for future use. |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_OBJECT_ID
, REFRESH_TEMPLATE_ID
, OBJECT_NAME
, OBJECT_TYPE
, DDL_TEXT
, MASTER_ROLLBACK_SEG
, DERIVED_FROM_SNAME
, DERIVED_FROM_ONAME
, FLAVOR_ID
, DDL_NUM
, SCHEMA_NAME
, OBJECT_VERSION#
, TEMPLATE_REFGROUP_ID
, FLAGS
, SPARE1
FROM SYSTEM.REPCAT$_TEMPLATE_OBJECTS;
SYSTEM.REPCAT$_TEMPLATE_OBJECTS does not reference any database object
SYSTEM.REPCAT$_TEMPLATE_OBJECTS is referenced by following:
|
|
|