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$_PUSHED_TRANSACTIONS

Object Details

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

Information about deferred transactions pushed to this site by RepAPI clients

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: DEF$_PUSHED_TRAN_PRIMARY

SOURCE_SITE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
DEF$_PUSHED_TRAN_PRIMARY	NORMAL	UNIQUE	SYSTEM	SOURCE_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_SITE_ID	NUMBER		Yes	Originating database identifier for the deferred transaction
LAST_TRAN_ID	NUMBER			Last committed transaction
DISABLED	VARCHAR2	(1)		Disable propagation
SOURCE_SITE	VARCHAR2	(128)		Obsolete - do not use

Query Text

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


SELECT SOURCE_SITE_ID
,      LAST_TRAN_ID
,      DISABLED
,      SOURCE_SITE
FROM SYSTEM.DEF$_PUSHED_TRANSACTIONS;

Dependencies

[top of page]

SYSTEM.DEF$_PUSHED_TRANSACTIONS does not reference any database object

SYSTEM.DEF$_PUSHED_TRANSACTIONS is referenced by following:

SYS: DBMS_REFRESH_EXP_LWM - show dependent code