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

Object Details

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

Information about all deferred transactions

[View Source]

Columns

Name	Datatype	Length	Comments
DEFERRED_TRAN_ID	VARCHAR2	(30)	The transaction that enqueued the calls
DELIVERY_ORDER	NUMBER		Total ordering on transactions
DESTINATION_LIST	VARCHAR2	(1)	Determine destinations from deftrandest (D) or repcat (R)
START_TIME	TIMESTAMP(6)	(11)	Time original transaction enqueued

Query Text

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


SELECT DEFERRED_TRAN_ID
,      DELIVERY_ORDER
,      DESTINATION_LIST
,      START_TIME
FROM SYS.DEFTRAN;

Dependencies

[top of page]

SYS.DEFTRAN references the following:

SYSTEM: DEF$_AQCALL; DEF$_AQERROR

SYS.DEFTRAN is referenced by following:

PUBLIC: DEFTRAN