1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_PART_LOBS

3.5 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(128)

NOT NULL

Owner of the partitioned table containing the LOBs

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the partitioned table containing the LOBs

COLUMN_NAME

VARCHAR2(4000)

Name of the LOB column

LOB_NAME

VARCHAR2(128)

NOT NULL

Name of the partitioned LOB

LOB_INDEX_NAME

VARCHAR2(128)

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.

Possible values for SecureFiles:

  • NONE

  • AUTO

  • MIN

  • MAX

  • DEFAULT

  • INVALID

Possible values for BasicFiles:

  • YES

  • NO

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 - Not specified

    See Also: the *_LOBS and *_LOB_PARTITIONS views

  • YES

  • NO

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_FLASH_CACHE

VARCHAR2(7)

Default Database Smart Flash Cache hint to be used when adding a partition:

  • DEFAULT

  • KEEP

  • NONE

Solaris and Oracle Linux functionality only.

DEF_CELL_FLASH_CACHE

VARCHAR2(7)

Default cell flash cache hint to be used when adding a partition:

  • DEFAULT

  • KEEP

  • NONE

See Also: Oracle Exadata Storage Server Software documentation for more information

DEF_ENCRYPT

VARCHAR2(4)

Default value of ENCRYPT for a LOB data partition to be used when adding a partition.

Possible values for SecureFiles:

  • YES

  • NO

Possible value for BasicFiles:

  • NONE - Not applicable

DEF_COMPRESS

VARCHAR2(6)

Default value of COMPRESS for a LOB data partition to be used when adding a partition.

Possible values for SecureFiles:

  • LOW

  • MEDIUM

  • HIGH

  • NO - Compression is off

Possible value for BasicFiles:

  • NONE - Not applicable

DEF_DEDUPLICATE

VARCHAR2(15)

Default value of DEDUPLICATE for a LOB data partition to be used when adding a partition.

Possible values for SecureFiles:

  • LOB - Deduplicate

  • NO - Keep duplicates

Possible values for BasicFiles:

  • NONE - Not applicable

DEF_SECUREFILE

VARCHAR2(3)

Indicates whether the LOB is SecureFiles (YES) or not (NO)

See Also: