ALL_PART_LOBS provides table-level information about partitioned LOBs that are accessible to the current user, including default attributes for LOB data partitions.
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 |