|
TABLE_OWNER
|
VARCHAR2(30)
|
|
Owner of the table
|
|
TABLE_NAME
|
VARCHAR2(30)
|
|
Name of the table
|
|
COLUMN_NAME
|
VARCHAR2(30)
|
|
Name of the LOB column
|
|
LOB_NAME
|
VARCHAR2(30)
|
|
Name of the partitioned LOB item
|
|
LOB_PARTITION_NAME
|
VARCHAR2(30)
|
|
Name of LOB data partition to which this LOB data subpartition belongs
|
|
SUBPARTITION_NAME
|
VARCHAR2(30)
|
|
Name of the table subpartition to which this LOB subpartition corresponds
|
|
LOB_SUBPARTITION_NAME
|
VARCHAR2(30)
|
|
Name of the LOB subpartition
|
|
LOB_INDSUBPART_NAME
|
VARCHAR2(30)
|
|
Name of corresponding LOB index subpartition
|
|
SUBPARTITION_POSITION
|
NUMBER
|
|
Position of the LOB data partition within the LOB item
|
|
CHUNK
|
NUMBER
|
|
Value of the CHUNK attribute of the LOB data partition
|
|
PCTVERSION
|
NUMBER
|
|
Value of the PCTVERSION attribute of the LOB data partition
|
|
CACHE
|
VARCHAR2(3)
|
|
Whether and how the cluster is to be cached in the buffer cache (CACHE, NOCACHE, CACHEREADS)
|
|
IN_ROW
|
VARCHAR2(3)
|
|
Whether the STORAGE IN ROW attribute of the LOB data partition is enabled
|
|
TABLESPACE_NAME
|
VARCHAR2(30)
|
|
Name of the tablespace containing the LOB data partition
|
|
INITIAL_EXTENT
|
VARCHAR2(40)
|
|
Size in bytes of the initial extent for the LOB data partition
|
|
NEXT_EXTENT
|
VARCHAR2(40)
|
|
Size in bytes of secondary extents for the LOB data partition
|
|
MIN_EXTENTS
|
VARCHAR2(40)
|
|
Minimum number of extents allowed in the segment of the LOB data partition
|
|
MAX_EXTENTS
|
VARCHAR2(40)
|
|
Maximum number of extents allowed in the segment of the LOB data partition
|
|
PCT_INCREASE
|
VARCHAR2(40)
|
|
Percentage increase in extent size for the LOB data partition
|
|
FREELISTS
|
VARCHAR2(40)
|
|
Number of process freelists allocated in the segment of the LOB data partition
|
|
FREELIST_GROUPS
|
VARCHAR2(40)
|
|
Number of freelist groups allocated in the segment of the LOB data partition
|
|
LOGGING
|
VARCHAR2(7)
|
|
Logging attribute of the LOB data partition
|
|
BUFFER_POOL
|
VARCHAR2(7)
|
|
Default buffer pool to be used for the LOB data partition blocks
|
