|
OWNER
|
VARCHAR2(30)
|
NOT NULL
|
Owner of the partitioned index
|
|
INDEX_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the partitioned index
|
|
TABLE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the 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
|
|
DEF_PARAMETERS
|
VARCHAR2(1000)
|
|
Default parameter string for domain indexes
|
