ALL_PART_LOBS

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(4000)`		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(10)`		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