[Home] [Help] [Dependency Information]
Object Name: | SCHEDULER$_SCHEDULE |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SCHEDULER$_SCHEDULE_PK | NORMAL | UNIQUE | SYSTEM | OBJ# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
RECURRENCE_EXPR | VARCHAR2 | (4000) | ||
QUEUE_OWNER | VARCHAR2 | (128) | ||
QUEUE_NAME | VARCHAR2 | (128) | ||
QUEUE_AGENT | VARCHAR2 | (128) | ||
REFERENCE_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
COMMENTS | VARCHAR2 | (240) | ||
FLAGS | NUMBER | |||
MAX_COUNT | NUMBER | |||
FW_NAME | VARCHAR2 | (261) |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, RECURRENCE_EXPR
, QUEUE_OWNER
, QUEUE_NAME
, QUEUE_AGENT
, REFERENCE_DATE
, END_DATE
, COMMENTS
, FLAGS
, MAX_COUNT
, FW_NAME
FROM SYS.SCHEDULER$_SCHEDULE;
SYS.SCHEDULER$_SCHEDULE does not reference any database object
SYS.SCHEDULER$_SCHEDULE is referenced by following:
|
|
|