[Home] [Help] [Dependency Information]
Object Name: | ODM_MESSAGE_LOG |
---|---|
Object Type: | TABLE |
Owner: | ODM |
Subobject Name: | |
Status: | VALID |
Tablespace: | ODM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MESSAGE_LOG_PK | NORMAL | UNIQUE | ODM | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | (20) | Yes | |
MESSAGE_ID | NUMBER | (6) | ||
MESSAGE_TYPE | VARCHAR2 | (32) | ||
MESSAGE_GROUP | VARCHAR2 | (64) | ||
MESSAGE_LEVEL | NUMBER | (2) | ||
TIMESTAMP_ORIGINATING | TIMESTAMP(6) | (11) | ||
TIMESTAMP_NORMALIZED | TIMESTAMP(6) | (11) | ||
ORGANIZATION_ID | VARCHAR2 | (16) | ||
COMPONENT_ID | VARCHAR2 | (32) | ||
HOST_ID | VARCHAR2 | (100) | ||
HOST_IP_ADDRESS | VARCHAR2 | (32) | ||
MODULE_ID | VARCHAR2 | (80) | ||
PROCESS_ID | VARCHAR2 | (65) | ||
USER_ID | VARCHAR2 | (80) | ||
UPSTREAM_COMPONENT | VARCHAR2 | (32) | ||
DOWNSTREAM_COMPONENT | VARCHAR2 | (32) | ||
EXECUTION_CONTEXT_ID | NUMBER | (20) | ||
ERROR_INSTANCE_ID | NUMBER | (20) | ||
MESSAGE_TEXT | VARCHAR2 | (1300) | ||
SUPPLEMENTAL_DETAILS | VARCHAR2 | (1300) | ||
ERROR_MESSAGE_STACK | VARCHAR2 | (1300) | ||
ERROR_MESSAGE_STACK2 | VARCHAR2 | (1300) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, MESSAGE_ID
, MESSAGE_TYPE
, MESSAGE_GROUP
, MESSAGE_LEVEL
, TIMESTAMP_ORIGINATING
, TIMESTAMP_NORMALIZED
, ORGANIZATION_ID
, COMPONENT_ID
, HOST_ID
, HOST_IP_ADDRESS
, MODULE_ID
, PROCESS_ID
, USER_ID
, UPSTREAM_COMPONENT
, DOWNSTREAM_COMPONENT
, EXECUTION_CONTEXT_ID
, ERROR_INSTANCE_ID
, MESSAGE_TEXT
, SUPPLEMENTAL_DETAILS
, ERROR_MESSAGE_STACK
, ERROR_MESSAGE_STACK2
FROM ODM.ODM_MESSAGE_LOG;
ODM.ODM_MESSAGE_LOG does not reference any database object
ODM.ODM_MESSAGE_LOG is referenced by following:
|
|
|