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

TABLE: SYS.SCHEDULER$_CONSTRAINTS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SCHEDULER$_CONST_PK
  1. ColumnOID
  2. ColumnRESOID
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_CONST_PK NORMAL UNIQUE TablespaceSYSTEM ColumnOID
ColumnRESOID
Columns
Name Datatype Length Mandatory Comments
OID NUMBER
Yes
RESOID NUMBER
Yes
RESOURCE_COUNT NUMBER

OID_TYPE NUMBER

Query Text

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


SELECT OID
,      RESOID
,      RESOURCE_COUNT
,      OID_TYPE
FROM SYS.SCHEDULER$_CONSTRAINTS;

Dependencies

[top of page]

SYS.SCHEDULER$_CONSTRAINTS does not reference any database object

SYS.SCHEDULER$_CONSTRAINTS is not referenced by any database object