[Home] [Help] [Dependency Information]

TABLE: SYS.WI$_TEMPLATE

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WI$_TEMPLATE_PK

1. JOBID
2. TEMPLATEID

Indexes

Index	Type	Uniqueness	Tablespace	Column
WI$_TEMPLATE_PK	NORMAL	UNIQUE	SYSAUX	JOBID TEMPLATEID

Foreign Keys

Table		Foreign Table	Foreign Key Column
WI$_TEMPLATE		WI$_JOB	WI$_TEMPLATE JOBID
WI$_EXECUTION_ORDER		WI$_TEMPLATE	WI$_EXECUTION_ORDER JOBID WI$_EXECUTION_ORDER TEMPLATEID
WI$_FREQUENT_PATTERN_ITEM		WI$_TEMPLATE	WI$_FREQUENT_PATTERN_ITEM JOBID WI$_FREQUENT_PATTERN_ITEM TEMPLATEID
WI$_OBJECT		WI$_TEMPLATE	WI$_OBJECT JOBID WI$_OBJECT TEMPLATEID
WI$_STATEMENT		WI$_TEMPLATE	WI$_STATEMENT JOBID WI$_STATEMENT TEMPLATEID

Columns

Query Text

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

SELECT JOBID
,      TEMPLATEID
,      ISTRANSACTION
FROM SYS.WI$_TEMPLATE;

Dependencies

[top of page]

SYS.WI$_TEMPLATE does not reference any database object

SYS.WI$_TEMPLATE is referenced by following:

SYS

DBA_WI_TEMPLATES