TABLE_OWNER |
VARCHAR2(30) |
|
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
|
Name of the table |
COLUMN_NAME |
VARCHAR2(4000) |
|
Name of the LOB column |
LOB_NAME |
VARCHAR2(30) |
|
Name of the partitioned LOB item |
PARTITION_NAME |
VARCHAR2(30) |
|
Name of the table partition |
LOB_PARTITION_NAME |
VARCHAR2(30) |
|
Name of the LOB data partition |
LOB_INDPART_NAME |
VARCHAR2(30) |
|
Name of the corresponding LOB index partition |
PARTITION_POSITION |
NUMBER |
|
Position of the LOB data partition within the LOB item |
COMPOSITE |
VARCHAR2(3) |
|
Whether the partition is composite (YES | NO) |
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(10) |
|
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 is enabled for the LOB data partition |
TABLESPACE_NAME |
VARCHAR2(30) |
|
Name of the tablespace containing the LOB data partition |
INITIAL_EXTENT |
VARCHAR2(40) |
|
Size in bytes of the initial extent of the LOB data partition |
NEXT_EXTENT |
VARCHAR2(40) |
|
Size in bytes of secondary extents of 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 for the LOB partition blocks |
ENCRYPT |
VARCHAR2(3) |
|
Whether or not the LOB is encrypted |
COMPRESSION |
VARCHAR2(6) |
|
The level of compression used for this LOB |
DEDUPLICATION |
VARCHAR2(15) |
|
The kind of deduplication used for this LOB |
SECUREFILE |
VARCHAR2(3) |
|
Indicates whether the LOB is a SecureFile LOB (YES) or not (NO) |
