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


TABLE: SYSTEM.AQ$_SCHEDULES

Object Details
Object Name: AQ$_SCHEDULES
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: AQ$_SCHEDULES_PRIMARY
  1. ColumnOID
  2. ColumnDESTINATION
Unique Key: AQ$_SCHEDULES_CHECK
  1. ColumnJOBNO
Indexes
Index Type Uniqueness Tablespace Column
AQ$_SCHEDULES_CHECK NORMAL UNIQUE TablespaceSYSTEM ColumnJOBNO
AQ$_SCHEDULES_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnOID
ColumnDESTINATION
Columns
Name Datatype Length Mandatory Comments
OID RAW (16) Yes
DESTINATION VARCHAR2 (128) Yes
START_TIME DATE

DURATION VARCHAR2 (8)
NEXT_TIME VARCHAR2 (128)
LATENCY VARCHAR2 (8)
LAST_TIME DATE

JOBNO NUMBER

Query Text

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


SELECT OID
,      DESTINATION
,      START_TIME
,      DURATION
,      NEXT_TIME
,      LATENCY
,      LAST_TIME
,      JOBNO
FROM SYSTEM.AQ$_SCHEDULES;

Dependencies

[top of page]

SYSTEM.AQ$_SCHEDULES does not reference any database object

SYSTEM.AQ$_SCHEDULES is not referenced by any database object