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 |