ALL_PART_LOBS

ALL_PART_LOBS provides table-level information about partitioned LOBs that are accessible to the current user, including default attributes for LOB data partitions.

Related Views

• DBA_PART_LOBS provides such information for all partitioned LOBs in the database.
• USER_PART_LOBS provides such information for all partitioned LOBs owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the partitioned table containing LOB(s)
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the partitioned table containing LOB(s)
  COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the LOB column
  LOB_NAME	VARCHAR2(30)	NOT NULL	Name of the partitioned LOB
  LOB_INDEX_NAME	VARCHAR2(30)	NOT NULL	Name of the partitioned LOB index
  DEF_CHUNK	NUMBER	NOT NULL	Default value of CHUNK for a LOB data partition to be used when adding a partition
  DEF_PCTVERSION	NUMBER	NOT NULL	Default value of PCTVERSION for a LOB data partition to be used when adding a partition
  DEF_CACHE	VARCHAR2(3)		Whether and how the cluster is to be cached by default in the buffer cache (CACHE, NOCACHE, CACHEREADS)
  DEF_IN_ROW	VARCHAR2(3)		Whether LOB data < 4000 bytes is stored in the row (inline)--that is, whether ENABLE STORAGE IN ROW was specified when the LOB column was created or last altered
  DEF_TABLESPACE_NAME	VARCHAR2(30)		Default tablespace for a LOB data partition to be used when adding a partition
  DEF_INITIAL_EXTENT	VARCHAR2(40)		Default value of INITIAL for a LOB data partition to be used when adding a partition
  DEF_NEXT_EXTENT	VARCHAR2(40)		Default value of NEXT for a LOB data partition to be used when adding a partition
  DEF_MIN_EXTENTS	VARCHAR2(40)		Default value of MINEXTENT for a LOB data partition to be used when adding a partition
  DEF_MAX_EXTENTS	VARCHAR2(40)		Default value of MAXEXTENTS for a LOB data partition to be used when adding a partition
  DEF_PCT_INCREASE	VARCHAR2(40)		Default value of PCTINCREASE for a LOB data partition to be used when adding a partition
  DEF_FREELISTS	VARCHAR2(40)		Default value of FREELISTS for a LOB data partition to be used when adding a partition
  DEF_FREELIST_GROUPS	VARCHAR2(40)		Default value of FREELIST GROUPS for a LOB data partition to be used when adding a partition
  DEF_LOGGING	VARCHAR2(7)		Default LOGGING attribute for a LOB data partition to be used when adding a partition
  DEF_BUFFER_POOL	VARCHAR2(7)		Default buffer pool for a LOB data partition to be used when adding a partition