ALL_PART_LOBS

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

Related Views

DBA_PART_LOBS displays table-level information about all partitioned LOBs in the database.
USER_PART_LOBS displays table-level information about the partitioned LOBs 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 partitioned table containing the LOBs
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the partitioned table containing the LOBs
`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)`		Indicates whether and how the LOB data is cached by default in the buffer cache: `YES` - LOB data is placed in the buffer cache `NO` - LOB data either is not brought into the buffer cache or is brought into the buffer cache and placed at the least recently used end of the LRU list `CACHEREADS` - LOB data is brought into the buffer cache only during read operations but not during write operations
`DEF_IN_ROW`	`VARCHAR2(3)`		Indicates whether LOB data < 4000 bytes is stored by default inline (in the row) (`YES`) or not (`NO`); that is, whether or not `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, or `DEFAULT` if no `INITIAL` value was specified
`DEF_NEXT_EXTENT`	`VARCHAR2(40)`		Default value of `NEXT` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `NEXT` value was specified
`DEF_MIN_EXTENTS`	`VARCHAR2(40)`		Default value of `MINEXTENTS` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `MINEXTENTS` value was specified
`DEF_MAX_EXTENTS`	`VARCHAR2(40)`		Default value of `MAXEXTENTS` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `MAXEXTENTS` value was specified
`DEF_MAX_SIZE`	`VARCHAR2(40)`		Default value of `MAXSIZE` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `MAXSIZE` value was specified
`DEF_RETENTION`	`VARCHAR2(7)`		Default value of `RETENTION` for a LOB data partition to be used when adding a partition: `NONE` `AUTO` `MIN` `MAX` `DEFAULT` `INVALID`
`DEF_MINRET`	`VARCHAR2(40)`		Default value of `RETENTION MIN` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `RETENTION MIN` value was specified
`DEF_PCT_INCREASE`	`VARCHAR2(40)`		Default value of `PCTINCREASE` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `PCTINCREASE` value was specified
`DEF_FREELISTS`	`VARCHAR2(40)`		Default value of `FREELISTS` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `FREELISTS` value was specified
`DEF_FREELIST_GROUPS`	`VARCHAR2(40)`		Default value of `FREELIST GROUPS` for a LOB data partition to be used when adding a partition, or `DEFAULT` if no `FREELIST GROUPS` value was specified
`DEF_LOGGING`	`VARCHAR2(7)`		Default `LOGGING` attribute for a LOB data partition to be used when adding a partition: `NONE` `YES` `NO` `UNKNOWN`
`DEF_BUFFER_POOL`	`VARCHAR2(7)`		Default buffer pool for a LOB data partition to be used when adding a partition: `DEFAULT` `KEEP` `RECYCLE` NULL
`DEF_ENCRYPT`	`VARCHAR2(4)`		Default value of `ENCRYPT` for a LOB data partition to be used when adding a partition: `YES` `NO` `NONE`
`DEF_COMPRESS`	`VARCHAR2(6)`		Default value of `COMPRESS` for a LOB data partition to be used when adding a partition: `LOW` `MEDIUM` `HIGH` `NO` `NONE`
`DEF_DEDUPLICATE`	`VARCHAR2(15)`		Default value of `DEDUPLICATE` for a LOB data partition to be used when adding a partition: `LOB` `OBJECT` `LOB VALIDATE` `OBJECT VALIDATE` `NO` `NONE`
`DEF_SECUREFILE`	`VARCHAR2(3)`		Indicates whether the LOB is a SecureFile LOB (`YES`) or not (`NO`)