eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_APPLY_ERROR

Object Details

Object Name:	USER_APPLY_ERROR
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Error transactions owned by an apply visible to the current user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLY_NAME	VARCHAR2	(128)	Yes	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

Query Text

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.USER_APPLY_ERROR;

Dependencies

[top of page]

SYS.USER_APPLY_ERROR references the following:

SYS: DBA_APPLY_ERROR; STREAMS$_APPLY_PROCESS; USER$

SYS.USER_APPLY_ERROR is referenced by following:

PUBLIC: USER_APPLY_ERROR