[Home] [Help] [Dependency Information]
Object Name: | SCHEDULER$_STEP_STATE |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SCHEDULER$_STEP_STATE_PK | NORMAL | UNIQUE | SYSAUX |
JOB_OID
STEP_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_OID | NUMBER | Yes | ||
STEP_NAME | VARCHAR2 | (128) | Yes | |
STATUS | CHAR | (1) | ||
ERROR_CODE | NUMBER | |||
START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
JOB_STEP_OID | NUMBER | |||
JOB_STEP_LOG_ID | NUMBER | |||
DESTINATION | VARCHAR2 | (128) | ||
FLAGS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_OID
, STEP_NAME
, STATUS
, ERROR_CODE
, START_DATE
, END_DATE
, JOB_STEP_OID
, JOB_STEP_LOG_ID
, DESTINATION
, FLAGS
FROM SYS.SCHEDULER$_STEP_STATE;
SYS.SCHEDULER$_STEP_STATE does not reference any database object
SYS.SCHEDULER$_STEP_STATE is referenced by following:
|
|
|