[Home] [Help] [Dependency Information]
Object Name: | DBA_APPLY_ERROR |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Error transactions
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLY_NAME | VARCHAR2 | (128) | Name of the apply process at the local site which processed the transaction | |
QUEUE_NAME | VARCHAR2 | (128) | Yes | Name of the queue at the local site where the transaction came from |
QUEUE_OWNER | VARCHAR2 | (128) | Yes | Owner of the queue at the local site where the transaction came from |
LOCAL_TRANSACTION_ID | VARCHAR2 | (22) | Local transaction ID for the error creation transaction | |
SOURCE_DATABASE | VARCHAR2 | (128) | Database where the transaction originated | |
SOURCE_TRANSACTION_ID | VARCHAR2 | (128) | Original transaction ID at the source database | |
SOURCE_COMMIT_SCN | NUMBER | Original commit SCN for the transaction at the source database | ||
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 | |
RECIPIENT_ID | NUMBER | User ID of the original recipient | ||
RECIPIENT_NAME | VARCHAR2 | (128) | Name of the original recipient | |
MESSAGE_COUNT | NUMBER | Total number of messages inside the error transaction | ||
ERROR_CREATION_TIME | DATE | The time that this error was created | ||
SOURCE_COMMIT_POSITION | RAW | (64) | Original commit position for the transaction | |
ERROR_TYPE | VARCHAR2 | (23) | The type of the error transaction | |
SOURCE_ROOT_NAME | VARCHAR2 | (128) | Root Database where the transaction originated | |
ERROR_POSITION | RAW | (64) | Position of the LCR that encountered the error |
Cut, paste (and edit) the following text to query this object:
SELECT APPLY_NAME
, QUEUE_NAME
, QUEUE_OWNER
, LOCAL_TRANSACTION_ID
, SOURCE_DATABASE
, SOURCE_TRANSACTION_ID
, SOURCE_COMMIT_SCN
, MESSAGE_NUMBER
, ERROR_NUMBER
, ERROR_MESSAGE
, RECIPIENT_ID
, RECIPIENT_NAME
, MESSAGE_COUNT
, ERROR_CREATION_TIME
, SOURCE_COMMIT_POSITION
, ERROR_TYPE
, SOURCE_ROOT_NAME
, ERROR_POSITION
FROM SYS.DBA_APPLY_ERROR;
|
|
|