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

Object Details

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

Information about all deferred transactions that caused an error

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEFERRED_TRAN_ID	VARCHAR2	(22)	Yes	The ID of the transaction that created the error
ORIGIN_TRAN_DB	VARCHAR2	(128)		The database originating the deferred transaction
ORIGIN_TRAN_ID	VARCHAR2	(22)		The original ID of the transaction
CALLNO	NUMBER			Unique ID of call that caused an error
DESTINATION	VARCHAR2	(128)		Database link used to address destination
START_TIME	DATE			Time original transaction enqueued
ERROR_NUMBER	NUMBER			Oracle error number
ERROR_MSG	VARCHAR2	(2000)		Error message text
RECEIVER	VARCHAR2	(128)		The original receiver of the deferred transaction

Query Text

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


SELECT DEFERRED_TRAN_ID
,      ORIGIN_TRAN_DB
,      ORIGIN_TRAN_ID
,      CALLNO
,      DESTINATION
,      START_TIME
,      ERROR_NUMBER
,      ERROR_MSG
,      RECEIVER
FROM SYS.DEFERROR;

Dependencies

[top of page]

SYS.DEFERROR references the following:

SYS: USER$
SYSTEM: DEF$_ERROR

SYS.DEFERROR is referenced by following:

PUBLIC: DEFERROR
SYS: DEFERRCOUNT