DBA Data[Home] [Help] [Dependency Information]


TABLE: SYSTEM.LOGMNR_SPILL$

Object Details
Object Name: LOGMNR_SPILL$
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: LOGMNR_SPILL$_PK
  1. ColumnSESSION#
  2. ColumnXIDUSN
  3. ColumnXIDSLT
  4. ColumnXIDSQN
  5. ColumnCHUNK
  6. ColumnSTARTIDX
  7. ColumnENDIDX
  8. ColumnFLAG
  9. ColumnSEQUENCE#
Indexes
Index Type Uniqueness Tablespace Column
LOGMNR_SPILL$_PK NORMAL UNIQUE TablespaceSYSAUX ColumnSESSION#
ColumnXIDUSN
ColumnXIDSLT
ColumnXIDSQN
ColumnCHUNK
ColumnSTARTIDX
ColumnENDIDX
ColumnFLAG
ColumnSEQUENCE#
SYS_IL0000598962C00010$$ LOB UNIQUE TablespaceSYSAUX
Columns
Name Datatype Length Mandatory Comments
SESSION# NUMBER
Yes
XIDUSN NUMBER
Yes
XIDSLT NUMBER
Yes
XIDSQN NUMBER
Yes
CHUNK NUMBER
Yes
STARTIDX NUMBER
Yes
ENDIDX NUMBER
Yes
FLAG NUMBER
Yes
SEQUENCE# NUMBER
Yes
SPILL_DATA BLOB (4000)
SPARE1 NUMBER

SPARE2 NUMBER

Query Text

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


SELECT SESSION#
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      CHUNK
,      STARTIDX
,      ENDIDX
,      FLAG
,      SEQUENCE#
,      SPILL_DATA
,      SPARE1
,      SPARE2
FROM SYSTEM.LOGMNR_SPILL$;

Dependencies

[top of page]

SYSTEM.LOGMNR_SPILL$ does not reference any database object

SYSTEM.LOGMNR_SPILL$ is not referenced by any database object