|
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) |
|
The logging attribute of the LOB data partition |
|
BUFFER_POOL |
VARCHAR2(7) |
|
Default buffer pool to be used for the LOB data partition blocks |
