[Home] [Help] [Dependency Information]
Object Name: | STREAMS$_APPLY_SPILL_TXN |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_STREAMS_APPLY_SPILL_TXN | NORMAL | UNIQUE | SYSAUX |
APPLYNAME
XIDUSN XIDSLT XIDSQN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
SYS.STREAMS$_APPLY_SPILL_TXN does not reference any database object
SYS.STREAMS$_APPLY_SPILL_TXN is referenced by following:
|
|
|