[Home] [Help] [Dependency Information]

TABLE: SYS.ILM_RESULTS$

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: PK_RES

1. JOBNAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PK_RES	NORMAL	UNIQUE	SYSAUX	JOBNAME
SYS_IL0000625982C00010$$	LOB	UNIQUE	SYSAUX
I_ILM_RESULTS_EXECUTION_ID	NORMAL	NONUNIQUE	SYSAUX	EXECUTION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
ILM_RESULTS$		ILM_EXECUTION$	ILM_RESULTS$ EXECUTION_ID
ILM_DEPENDANT_OBJ$		ILM_RESULTS$	ILM_DEPENDANT_OBJ$ PAR_JOBNAME
ILM_DEP_EXECUTIONDETAILS$		ILM_RESULTS$	ILM_DEP_EXECUTIONDETAILS$ PAR_JOBNAME
ILM_RESULT_STAT$		ILM_RESULTS$	ILM_RESULT_STAT$ JOBNAME

Columns

Query Text

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

SELECT EXECUTION_ID
,      JOBNAME
,      JOBTYPE
,      JOBTYPE1
,      JOB_STATUS
,      START_TIME
,      COMPLETION_TIME
,      PAYLOAD
,      COMMENTS
,      STATISTICS
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.ILM_RESULTS$;

Dependencies

[top of page]

SYS.ILM_RESULTS$ does not reference any database object

SYS.ILM_RESULTS$ is referenced by following:

SYS

DBA_ILMRESULTS

PRVT_ILM - show dependent code

USER_ILMRESULTS