[Home] [Help] [Dependency Information]
Object Name: | CDB_APPLY_ERROR_MESSAGES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about individual messages in an error transaction in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MESSAGE_ID | RAW | (16) | AQ message ID for a message stored in the AQ exception queue | |
LOCAL_TRANSACTION_ID | VARCHAR2 | (22) | Local transaction ID for the error creation transaction | |
TRANSACTION_MESSAGE_NUMBER | NUMBER | Identifier for the message in the transaction that raised an error | ||
ERROR_NUMBER | NUMBER | Error number | ||
ERROR_MESSAGE | VARCHAR2 | (4000) | Error message | |
SOURCE_OBJECT_OWNER | VARCHAR2 | (30) | Owner of the object at the source database | |
SOURCE_OBJECT_NAME | VARCHAR2 | (30) | Name of the object at the source database | |
OBJECT_OWNER | VARCHAR2 | (30) | Owner of the object | |
OBJECT_NAME | VARCHAR2 | (30) | Name of the object | |
PRIMARY_KEY | VARCHAR2 | (4000) | Primary key information | |
POSITION | RAW | (64) | Position information | |
OPERATION | VARCHAR2 | (100) | Message operation | |
MESSAGE | CLOB | (4000) | Message content | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT MESSAGE_ID
, LOCAL_TRANSACTION_ID
, TRANSACTION_MESSAGE_NUMBER
, ERROR_NUMBER
, ERROR_MESSAGE
, SOURCE_OBJECT_OWNER
, SOURCE_OBJECT_NAME
, OBJECT_OWNER
, OBJECT_NAME
, PRIMARY_KEY
, POSITION
, OPERATION
, MESSAGE
, CON_ID
FROM SYS.CDB_APPLY_ERROR_MESSAGES;
SYS.CDB_APPLY_ERROR_MESSAGES does not reference any database object
SYS.CDB_APPLY_ERROR_MESSAGES is referenced by following:
|
|
|