DBA_LOB_SUBPARTITIONS

DBA_LOB_SUBPARTITIONS displays partition-level attributes of all LOB data subpartitions in the database. Its columns are the same as those in "ALL_LOB_SUBPARTITIONS".

Related Views

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

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

Oracle data dictionary views

Oracle dynamic performance views