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.STREAMS$_APPLY_SPILL_TXN

Object Details

Object Name:	STREAMS$_APPLY_SPILL_TXN
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_STREAMS_APPLY_SPILL_TXN	NORMAL	UNIQUE	SYSAUX	APPLYNAME XIDUSN XIDSLT XIDSQN

Columns

Name	Datatype	Length	Mandatory
APPLYNAME	VARCHAR2	(128)	Yes
XIDUSN	NUMBER		Yes
XIDSLT	NUMBER		Yes
XIDSQN	NUMBER		Yes
FIRST_SCN	NUMBER		Yes
LAST_SCN	NUMBER
LAST_SCN_SEQ	NUMBER
LAST_CAP_INSTNO	NUMBER
COMMIT_SCN	NUMBER
SPILLCOUNT	NUMBER
ERR_NUM	NUMBER
ERR_IDX	NUMBER
SENDER	VARCHAR2	(128)
FLAGS	NUMBER
PRIV_STATE	NUMBER
DISTRIB_CSCN	NUMBER
SRC_COMMIT_TIME	NUMBER
DEP_FLAG	NUMBER
SPILL_FLAGS	NUMBER
FIRST_MESSAGE_CREATE_TIME	DATE
SPILL_CREATION_TIME	DATE
TXNKEY	NUMBER
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	NUMBER
SPARE5	VARCHAR2	(4000)
SPARE6	VARCHAR2	(4000)
SPARE7	VARCHAR2	(4000)
FIRST_POSITION	RAW	(64)
LAST_POSITION	RAW	(64)
COMMIT_POSITION	RAW	(64)
LAST_MESSAGE_CREATE_TIME	DATE
TRANSACTION_ID	VARCHAR2	(128)
PARENT_TRANSACTION_ID	VARCHAR2	(128)
SPARE8	DATE
SPARE9	RAW	(100)

Query Text

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


SELECT APPLYNAME
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      FIRST_SCN
,      LAST_SCN
,      LAST_SCN_SEQ
,      LAST_CAP_INSTNO
,      COMMIT_SCN
,      SPILLCOUNT
,      ERR_NUM
,      ERR_IDX
,      SENDER
,      FLAGS
,      PRIV_STATE
,      DISTRIB_CSCN
,      SRC_COMMIT_TIME
,      DEP_FLAG
,      SPILL_FLAGS
,      FIRST_MESSAGE_CREATE_TIME
,      SPILL_CREATION_TIME
,      TXNKEY
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      FIRST_POSITION
,      LAST_POSITION
,      COMMIT_POSITION
,      LAST_MESSAGE_CREATE_TIME
,      TRANSACTION_ID
,      PARENT_TRANSACTION_ID
,      SPARE8
,      SPARE9
FROM SYS.STREAMS$_APPLY_SPILL_TXN;

Dependencies

[top of page]

SYS.STREAMS$_APPLY_SPILL_TXN does not reference any database object

SYS.STREAMS$_APPLY_SPILL_TXN is referenced by following:

SYS: DBMS_APPLY_ERROR - show dependent code; DBMS_CAPTURE_SWITCH_INTERNAL - show dependent code; _DBA_APPLY_SPILL_TXN