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

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_TEMPLATE_OBJECTS_PK

TEMPLATE_OBJECT_ID

Unique Key: REPCAT$_TEMPLATE_OBJECTS_U1

OBJECT_NAME
OBJECT_TYPE
REFRESH_TEMPLATE_ID
SCHEMA_NAME
DDL_NUM

Indexes

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

Foreign Keys

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

Columns

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.

Query Text

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;

Dependencies

[top of page]

SYSTEM.REPCAT$_TEMPLATE_OBJECTS does not reference any database object

SYSTEM.REPCAT$_TEMPLATE_OBJECTS is referenced by following:

SYS: ALL_REPCAT_TEMPLATE_OBJECTS; DBA_IAS_GEN_STMTS; DBA_IAS_GEN_STMTS_EXP; DBA_IAS_OBJECTS_BASE; DBA_IAS_OBJECTS_EXP; DBA_REPCAT_TEMPLATE_OBJECTS; 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_TEMPLATE_OBJECTS