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


TABLE: SYS.SCHEDULER$_WINGRP_MEMBER

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: SCHEDULER$_WINGRP_MEMBER_UQ
  1. ColumnOID
  2. ColumnMEMBER_OID
  3. ColumnMEMBER_OID2
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_WINGRP_MEMBER_UQ NORMAL UNIQUE TablespaceSYSTEM ColumnOID
ColumnMEMBER_OID
ColumnMEMBER_OID2
I_SCHEDULER_WINGRP_MEMBER1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnOID
I_SCHEDULER_WINGRP_MEMBER2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnMEMBER_OID
I_SCHEDULER_WINGRP_MEMBER3 NORMAL NONUNIQUE TablespaceSYSTEM ColumnMEMBER_OID2
Columns
Name Datatype Length Mandatory Comments
OID NUMBER
Yes
MEMBER_OID NUMBER
Yes
MEMBER_OID2 NUMBER

Query Text

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


SELECT OID
,      MEMBER_OID
,      MEMBER_OID2
FROM SYS.SCHEDULER$_WINGRP_MEMBER;

Dependencies

[top of page]

SYS.SCHEDULER$_WINGRP_MEMBER does not reference any database object

SYS.SCHEDULER$_WINGRP_MEMBER is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_GROUP_MEMBERS
ViewALL_SCHEDULER_JOB_DESTS
ViewDBA_SCHEDULER_GROUPS
ViewDBA_SCHEDULER_GROUP_MEMBERS
ViewDBA_SCHEDULER_JOB_DESTS
ViewDBA_SCHEDULER_WINDOW_GROUPS
ViewDBA_SCHEDULER_WINGROUP_MEMBERS
Package BodyDBMS_SCHED_MAIN_EXPORT - show dependent code
ViewUSER_SCHEDULER_GROUP_MEMBERS
ViewUSER_SCHEDULER_JOB_DESTS