DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.SCHEDULER$_CHAIN

Object Details
Object Name: SCHEDULER$_CHAIN
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SCHEDULER$_CHAIN_PK
  1. ColumnOBJ#
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_CHAIN_PK NORMAL UNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
RULE_SET VARCHAR2 (128)
RULE_SET_OWNER VARCHAR2 (128)
COMMENTS VARCHAR2 (240)
EVAL_INTERVAL INTERVAL DAY(3) TO SECOND(0) (11)
FLAGS NUMBER

Query Text

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


SELECT OBJ#
,      RULE_SET
,      RULE_SET_OWNER
,      COMMENTS
,      EVAL_INTERVAL
,      FLAGS
FROM SYS.SCHEDULER$_CHAIN;

Dependencies

[top of page]

SYS.SCHEDULER$_CHAIN does not reference any database object

SYS.SCHEDULER$_CHAIN is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_CHAINS
ViewALL_SCHEDULER_CHAIN_RULES
ViewDBA_SCHEDULER_CHAINS
ViewDBA_SCHEDULER_CHAIN_RULES
Package BodyDBMS_ISCHED - show dependent code
Package BodyDBMS_SCHED_MAIN_EXPORT - show dependent code
ViewUSER_SCHEDULER_CHAINS
ViewUSER_SCHEDULER_CHAIN_RULES