Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_LOB_SUBPARTITIONS
displays partition-level attributes of LOB data subpartitions accessible to the current user.
Related Views
DBA_LOB_SUBPARTITIONS
describes all LOB subpartitions in the database.
USER_LOB_SUBPARTITIONS
describes the LOB subpartitions owned by the current user. This view does not display the TABLE_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
COLUMN_NAME |
VARCHAR2(4000) |
Name of the LOB column | |
LOB_NAME |
VARCHAR2(30) |
NOT NULL |
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 |
NOT NULL |
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 of the LOB data partition is enabled |
|
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace containing the LOB data partition |
INITIAL_EXTENT |
NUMBER |
Size in bytes of the initial extent for the LOB data partition | |
NEXT_EXTENT |
NUMBER |
Size in bytes of secondary extents for the LOB data partition | |
MIN_EXTENTS |
NUMBER |
NOT NULL |
Minimum number of extents allowed in the segment of the LOB data partition |
MAX_EXTENTS |
NUMBER |
NOT NULL |
Maximum number of extents allowed in the segment of the LOB data partition |
PCT_INCREASE |
NUMBER |
Percentage increase in extent size for the LOB data partition | |
FREELISTS |
NUMBER |
Number of process freelists allocated in the segment of the LOB data partition | |
FREELIST_GROUPS |
NUMBER |
Number of freelist groups allocated in the segment of the LOB data partition | |
LOGGING |
VARCHAR2(3) |
Logging attribute of the LOB data partition | |
BUFFER_POOL |
VARCHAR2(7) |
Default buffer pool to be used for the LOB data partition blocks |