Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_LOB_SUBPARTITIONS

ALL_LOB_SUBPARTITIONS displays partition-level attributes of LOB data subpartitions accessible to the current user.

Related Views

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
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)