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: SYSTEM.DEF$_ORIGIN

Object Details

Object Name:	DEF$_ORIGIN
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Information about deferred transactions pushed to this site

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Comments
ORIGIN_DB	VARCHAR2	(128)	Originating database for the deferred transaction
ORIGIN_DBLINK	VARCHAR2	(128)	Database link from deferred transaction origin to this site
INUSR	NUMBER		Connected user receiving the deferred transaction
CSCN	NUMBER		Prepare SCN assigned at origin site
ENQ_TID	VARCHAR2	(22)	Transaction id assigned at origin site
RECO_SEQ_NO	NUMBER		Deferred transaction sequence number for recovery
CATCHUP	RAW	(16)	Used to break transaction into pieces

Query Text

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


SELECT ORIGIN_DB
,      ORIGIN_DBLINK
,      INUSR
,      CSCN
,      ENQ_TID
,      RECO_SEQ_NO
,      CATCHUP
FROM SYSTEM.DEF$_ORIGIN;

Dependencies

[top of page]

SYSTEM.DEF$_ORIGIN does not reference any database object

SYSTEM.DEF$_ORIGIN is referenced by following:

SYS: DBMS_DEFER_INTERNAL_SYS - show dependent code