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)		Owner of the table
  TABLE_NAME	VARCHAR2(30)		Name of the table
  COLUMN_NAME	VARCHAR2(30)		Name of the LOB column
  LOB_NAME	VARCHAR2(30)		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		Value of the PCTVERSION attribute of the LOB data partition
  CACHE	VARCHAR2(3)		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)		Name of the tablespace containing the LOB data partition
  INITIAL_EXTENT	VARCHAR2(40)		Size in bytes of the initial extent for the LOB data partition
  NEXT_EXTENT	VARCHAR2(40)		Size in bytes of secondary extents for 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 to be used for the LOB data partition blocks