ALL_LOB_SUBPARTITIONS

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