[Home] [Help] [Dependency Information]

TABLE: SYS.WI$_JOB

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: WI$_JOB_PK

1. JOBID

Unique Key: WI$_JOB_UK_1

1. JOBNAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
WI$_JOB_PK	NORMAL	UNIQUE	SYSAUX	JOBID
WI$_JOB_UK_1	NORMAL	UNIQUE	SYSAUX	JOBNAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
WI$_CAPTURE_FILE		WI$_JOB	WI$_CAPTURE_FILE JOBID
WI$_FREQUENT_PATTERN		WI$_JOB	WI$_FREQUENT_PATTERN JOBID
WI$_FREQUENT_PATTERN_METADATA		WI$_JOB	WI$_FREQUENT_PATTERN_METADATA JOBID
WI$_TEMPLATE		WI$_JOB	WI$_TEMPLATE JOBID

Columns

Query Text

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

SELECT JOBID
,      JOBNAME
,      PATH
FROM SYS.WI$_JOB;

Dependencies

[top of page]

SYS.WI$_JOB does not reference any database object

SYS.WI$_JOB is referenced by following:

SYS

DBA_WI_JOBS