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]

TABLE: SYS.APPLY$_ERROR

Object Details

Object Name:	APPLY$_ERROR
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
STREAMS$_APPLY_ERROR_UNQ	NORMAL	UNIQUE	SYSAUX	LOCAL_TRANSACTION_ID
STREAMS$_APPLY_ERROR_IDX_2	NORMAL	NONUNIQUE	SYSTEM	APPLY#

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)
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
ERROR_CREATION_TIME	DATE
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
SPARE6	NUMBER
SPARE7	NUMBER
SPARE8	VARCHAR2	(4000)
SPARE9	VARCHAR2	(4000)
SPARE10	RAW	(1000)
SPARE11	RAW	(1000)
SPARE12	TIMESTAMP(6)	(11)

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
,      SPARE1
,      SPARE2
,      SPARE3
,      ERROR_CREATION_TIME
,      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#
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      SPARE12
FROM SYS.APPLY$_ERROR;

Dependencies

[top of page]

SYS.APPLY$_ERROR does not reference any database object

SYS.APPLY$_ERROR is referenced by following:

SYS: ALL_CHANGE_SETS; DBMS_APPLY_ERROR - show dependent code; DBMS_LOGREP_IMP_INTERNAL - show dependent code; DBMS_XSTREAM_GG_INTERNAL - show dependent code; _DBA_APPLY_ERROR