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


TABLE: SYSTEM.LOGMNR_INTEGRATED_SPILL$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: LOGMNR_INTEG_SPILL$_PK
  1. ColumnSESSION#
  2. ColumnXIDUSN
  3. ColumnXIDSLT
  4. ColumnXIDSQN
  5. ColumnCHUNK
  6. ColumnFLAG
Indexes
Index Type Uniqueness Tablespace Column
LOGMNR_INTEG_SPILL$_PK NORMAL UNIQUE TablespaceSYSAUX ColumnSESSION#
ColumnXIDUSN
ColumnXIDSLT
ColumnXIDSQN
ColumnCHUNK
ColumnFLAG
SYS_IL0000599044C00009$$ LOB UNIQUE TablespaceSYSAUX
Columns
Name Datatype Length Mandatory Comments
SESSION# NUMBER
Yes
XIDUSN NUMBER
Yes
XIDSLT NUMBER
Yes
XIDSQN NUMBER
Yes
CHUNK NUMBER
Yes
FLAG NUMBER
Yes
CTIME DATE

MTIME DATE

SPILL_DATA BLOB (4000)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 DATE

SPARE5 DATE

Query Text

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


SELECT SESSION#
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      CHUNK
,      FLAG
,      CTIME
,      MTIME
,      SPILL_DATA
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
FROM SYSTEM.LOGMNR_INTEGRATED_SPILL$;

Dependencies

[top of page]

SYSTEM.LOGMNR_INTEGRATED_SPILL$ does not reference any database object

SYSTEM.LOGMNR_INTEGRATED_SPILL$ is not referenced by any database object