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