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

TABLE: SYS.DBMS_ALERT_INFO

Object Details
Object Name: DBMS_ALERT_INFO
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00246270
  1. ColumnNAME
  2. ColumnSID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00246270 NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
ColumnSID
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Yes
SID VARCHAR2 (30) Yes
CHANGED VARCHAR2 (1)
MESSAGE VARCHAR2 (1800)
Query Text

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


SELECT NAME
,      SID
,      CHANGED
,      MESSAGE
FROM SYS.DBMS_ALERT_INFO;

Dependencies

[top of page]

SYS.DBMS_ALERT_INFO does not reference any database object

SYS.DBMS_ALERT_INFO is referenced by following:

SchemaSYS
Package BodyDBMS_ALERT - show dependent code