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._DBA_APPLY_ERROR

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
LOCAL_TRANSACTION_ID	VARCHAR2	(22)
SOURCE_TRANSACTION_ID	VARCHAR2	(128)
SOURCE_DATABASE	VARCHAR2	(128)
QUEUE_OWNER	VARCHAR2	(128)	Yes
QUEUE_NAME	VARCHAR2	(128)	Yes
APPLY#	NUMBER		Yes
MESSAGE_NUMBER	NUMBER
MESSAGE_COUNT	NUMBER
MIN_STEP_NO	NUMBER
RECIPIENT_ID	NUMBER
RECIPIENT_NAME	VARCHAR2	(128)
SOURCE_COMMIT_SCN	NUMBER
ERROR_NUMBER	NUMBER
ERROR_MESSAGE	VARCHAR2	(4000)
AQ_TRANSACTION_ID	VARCHAR2	(30)
ERROR_CREATION_TIME	DATE
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
EXTERNAL_SOURCE_POS	RAW	(64)
SPARE4	RAW	(2000)
SPARE5	VARCHAR2	(4000)
COMMIT_TIME	NUMBER
XIDUSN	NUMBER
XIDSLT	NUMBER
XIDSQN	NUMBER
RETRY_COUNT	NUMBER
FLAGS	NUMBER
ERROR_POS	RAW	(64)
START_SEQ#	NUMBER
END_SEQ#	NUMBER
START_RBA	NUMBER
END_RBA	NUMBER
ERROR_SEQ#	NUMBER
ERROR_RBA	NUMBER
ERROR_INDEX#	NUMBER

Query Text

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


SELECT LOCAL_TRANSACTION_ID
,      SOURCE_TRANSACTION_ID
,      SOURCE_DATABASE
,      QUEUE_OWNER
,      QUEUE_NAME
,      APPLY#
,      MESSAGE_NUMBER
,      MESSAGE_COUNT
,      MIN_STEP_NO
,      RECIPIENT_ID
,      RECIPIENT_NAME
,      SOURCE_COMMIT_SCN
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      AQ_TRANSACTION_ID
,      ERROR_CREATION_TIME
,      SPARE1
,      SPARE2
,      SPARE3
,      EXTERNAL_SOURCE_POS
,      SPARE4
,      SPARE5
,      COMMIT_TIME
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      RETRY_COUNT
,      FLAGS
,      ERROR_POS
,      START_SEQ#
,      END_SEQ#
,      START_RBA
,      END_RBA
,      ERROR_SEQ#
,      ERROR_RBA
,      ERROR_INDEX#
FROM SYS._DBA_APPLY_ERROR;

Dependencies

[top of page]

SYS._DBA_APPLY_ERROR references the following:

SYS: APPLY$_ERROR

SYS._DBA_APPLY_ERROR is referenced by following:

SYS: DBA_APPLY_ERROR; DBMS_LOGREP_EXP - show dependent code