OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of this partitioned index |
INDEX_NAME |
VARCHAR2(30) |
NOT NULL |
Name of this partitioned index |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of this partitioned table |
PARTITIONING_TYPE |
VARCHAR2(7) |
|
RANGE , HASH , SYSTEM , or UNKNOWN |
SUBPARTITIONING_TYPE |
VARCHAR2(7) |
|
HASH , SYSTEM , or NONE |
PARTITION_COUNT |
NUMBER |
NOT NULL |
Number of partitions in this index |
DEF_SUBPARTITION_COUNT |
NUMBER |
NOT NULL |
For a composite-partitioned index, the default number of subpartitions, if specified |
PARTITIONING_KEY_COUNT |
NUMBER |
NOT NULL |
Number of columns in the partitioning key |
SUBPARTITIONING_KEY_COUNT |
NUMBER |
NOT NULL |
For a composite-partitioned index, the number of columns in the subpartitioning key |
LOCALITY |
VARCHAR2(6) |
|
Whether this partitioned index is LOCAL or GLOBAL |
ALIGNMENT |
VARCHAR2(12) |
|
Whether this partitioned index is PREFIXED or NON-PREFIXED |
DEF_TABLESPACE_NAME |
VARCHAR2(30) |
|
For a local index, the default tablespace to be used when adding or splitting a table partition |
DEF_PCT_FREE |
NUMBER |
NOT NULL |
For a local index, the default PCTFREE value to be used when adding a table partition |
DEF_INI_TRANS |
NUMBER |
NOT NULL |
For a local index, the default INITRANS to be used when adding a table partition |
DEF_MAX_TRANS |
NUMBER |
NOT NULL |
For a local index, the default MAXTRANS to be used when adding a table partition |
DEF_INITIAL_EXTENT |
VARCHAR2(40) |
NOT NULL |
For a local index, the default INITIAL value to be used when adding a table partition, or DEFAULT if no INITIAL value was specified. |
DEF_NEXT_EXTENT |
VARCHAR2(40) |
NOT NULL |
For a local index, the default NEXT , or DEFAULT if no NEXT value was specified. |
DEF_MIN_EXTENTS |
VARCHAR2(40) |
NOT NULL |
For a local index, the default MINEXTENTS value to be used when adding a table partition, or DEFAULT if no MINEXTENTS value was specified. |
DEF_MAX_EXTENTS |
VARCHAR2(40) |
NOT NULL |
For a local index, the default MAXEXTENTS value to be used when adding a table partition, or DEFAULT if no MAXEXTENTS value was specified. |
DEF_PCT_INCREASE |
VARCHAR2(40) |
NOT NULL |
For a local index, the default PCTINCREASE value to be used when adding a table partition, or DEFAULT if no PCTINCREASE value was specified. |
DEF_FREELISTS |
NUMBER |
NOT NULL |
For a local index, the default FREELISTS value to be used when adding a table partition, or DEFAULT if no FREELISTS value was specified. |
DEF_FREELIST_GROUPS |
NUMBER |
NOT NULL |
For a local index, the default FREELIST GROUPS value to be used when adding a table partition, or DEFAULT if no FREELIST GROUPS value was specified. |
DEF_LOGGING |
VARCHAR2(7) |
|
For a local index, the default LOGGING attribute to be used when adding a table partition, or DEFAULT if no LOGGING attribute was specified. |
DEF_BUFFER_POOL |
VARCHAR2(7) |
|
For a local index, the default buffer pool to be used when adding a table partition |