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]

VIEW: SYS.ALL_REPCAT_TEMPLATE_OBJECTS

Object Details

Object Name:	ALL_REPCAT_TEMPLATE_OBJECTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REFRESH_TEMPLATE_NAME	VARCHAR2	(30)	Yes	Name of the refresh group template.
OBJECT_NAME	VARCHAR2	(128)	Yes	Name of the database object.
OBJECT_TYPE	VARCHAR2	(200)		Type of database object.
DDL_NUM	NUMBER			Order of DDLs for creating the object.
DDL_TEXT	CLOB	(4000)		DDL string for creating the object or WHERE clause for snapshot query.
MASTER_ROLLBACK_SEGMENT	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.

Query Text

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


SELECT REFRESH_TEMPLATE_NAME
,      OBJECT_NAME
,      OBJECT_TYPE
,      DDL_NUM
,      DDL_TEXT
,      MASTER_ROLLBACK_SEGMENT
,      DERIVED_FROM_SNAME
,      DERIVED_FROM_ONAME
,      FLAVOR_ID
FROM SYS.ALL_REPCAT_TEMPLATE_OBJECTS;

Dependencies

[top of page]

SYS.ALL_REPCAT_TEMPLATE_OBJECTS references the following:

SYS: ALL_USERS; USER$
SYSTEM: REPCAT$_OBJECT_TYPES; REPCAT$_REFRESH_TEMPLATES; REPCAT$_TEMPLATE_OBJECTS; REPCAT$_TEMPLATE_TYPES; REPCAT$_USER_AUTHORIZATIONS

SYS.ALL_REPCAT_TEMPLATE_OBJECTS is referenced by following:

PUBLIC: ALL_REPCAT_TEMPLATE_OBJECTS