[Home] [Help] [Dependency Information]
Object Name: | DIR$ALERT_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_DIR$ALERT_HISTORY_ACTION_ID | NORMAL | NONUNIQUE | SYSAUX | ACTION_ID |
I_DIR$ALERT_HISTORY_AT | NORMAL | NONUNIQUE | SYSAUX | ACTION_TIME |
I_DIR$ALERT_HISTORY_NAME | NORMAL | NONUNIQUE | SYSAUX | ALERT_NAME |
I_DIR$ALERT_HISTORY_REASON_ID | NORMAL | NONUNIQUE | SYSAUX | REASON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALERT_NAME | VARCHAR2 | (200) | ||
MESSAGE_LEVEL | NUMBER | |||
ACTION_ID | NUMBER | |||
REASON_ID | NUMBER | |||
LAST_TIME | DATE | |||
NEXT_TIME | DATE | |||
ACTION_TIME | DATE | |||
INCARNATION_INFO | VARCHAR2 | (4000) | ||
JOB_NAME | VARCHAR2 | (100) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT ALERT_NAME
, MESSAGE_LEVEL
, ACTION_ID
, REASON_ID
, LAST_TIME
, NEXT_TIME
, ACTION_TIME
, INCARNATION_INFO
, JOB_NAME
, SPAREN1
, SPAREN2
, SPAREN3
, SPAREN4
, SPAREN5
, SPAREVC1
, SPAREVC2
, SPAREVC3
, SPAREVC4
, SPAREVC5
FROM SYS.DIR$ALERT_HISTORY;
SYS.DIR$ALERT_HISTORY does not reference any database object
SYS.DIR$ALERT_HISTORY is not referenced by any database object
|
|
|