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

TABLE: SYS.DIR$ESCALATE_OPERATIONS

Object Details
Object Name: DIR$ESCALATE_OPERATIONS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_DIR$ESCALATE_UI NORMAL UNIQUE TablespaceSYSAUX ColumnESCALATION_ID
ColumnSTATUS
I_DIR$ESCALATE_ALERT_SEQ_ID NORMAL NONUNIQUE TablespaceSYSAUX ColumnALERT_SEQ_ID
I_DIR$ESCALATE_END_TIME NORMAL NONUNIQUE TablespaceSYSAUX ColumnEND_TIME
I_DIR$ESCALATE_STATUS NORMAL NONUNIQUE TablespaceSYSAUX ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
ESCALATION_ID VARCHAR2 (200)
ALERT_SEQ_ID NUMBER

ESCALATION VARCHAR2 (20)
INCARNATION_INFO VARCHAR2 (4000)
INSTANCE_NAME VARCHAR2 (4000)
SUBMIT_TIME DATE

STATUS NUMBER

START_TIME DATE

END_TIME DATE

RETRY_TIME DATE

RETRY_COUNT NUMBER

ERROR_MESSAGE VARCHAR2 (4000)
SPAREN1 NUMBER

SPAREN2 NUMBER

SPAREN3 NUMBER

SPAREN4 NUMBER

SPAREN5 NUMBER

SPAREVC1 VARCHAR2 (4000)
SPAREVC2 VARCHAR2 (4000)
SPAREVC3 VARCHAR2 (4000)
SPAREVC4 VARCHAR2 (4000)
SPAREVC5 VARCHAR2 (4000)
Query Text

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


SELECT ESCALATION_ID
,      ALERT_SEQ_ID
,      ESCALATION
,      INCARNATION_INFO
,      INSTANCE_NAME
,      SUBMIT_TIME
,      STATUS
,      START_TIME
,      END_TIME
,      RETRY_TIME
,      RETRY_COUNT
,      ERROR_MESSAGE
,      SPAREN1
,      SPAREN2
,      SPAREN3
,      SPAREN4
,      SPAREN5
,      SPAREVC1
,      SPAREVC2
,      SPAREVC3
,      SPAREVC4
,      SPAREVC5
FROM SYS.DIR$ESCALATE_OPERATIONS;

Dependencies

[top of page]

SYS.DIR$ESCALATE_OPERATIONS does not reference any database object

SYS.DIR$ESCALATE_OPERATIONS is not referenced by any database object