DBA_PART_INDEXES

SQL>DESC DBA_PART_INDEXES

 Name                                          Null?                  Type
 ------------------------------------------------- ----------------------------

 OWNER                                            NOT NULL         VARCHAR2(30)
 INDEX_NAME                                NOT NULL          VARCHAR2(30)
 TABLE_NAME                                NOT NULL          VARCHAR2(30)
 PARTITIONING_TYPE                                                 VARCHAR2(7)
 SUBPARTITIONING_TYPE                                         VARCHAR2(7)
 PARTITION_COUNT                      NOT NULL           NUMBER
 DEF_SUBPARTITION_COUNT                                     NUMBER
 PARTITIONING_KEY_COUNT          NOT NULL        NUMBER
 SUBPARTITIONING_KEY_COUNT                             NUMBER
 LOCALITY                                                                      VARCHAR2(6)
 ALIGNMENT                                                                      VARCHAR2(12)
 DEF_TABLESPACE_NAME                                       VARCHAR2(30)
 DEF_PCT_FREE                              NOT NULL        NUMBER
 DEF_INI_TRANS                             NOT NULL        NUMBER
 DEF_MAX_TRANS                        NOT NULL        NUMBER
 DEF_INITIAL_EXTENT                                            VARCHAR2(40)
 DEF_NEXT_EXTENT                                                VARCHAR2(40)
 DEF_MIN_EXTENTS                                                 VARCHAR2(40)
 DEF_MAX_EXTENTS                                               VARCHAR2(40)
 DEF_MAX_SIZE                                                        VARCHAR2(40)
 DEF_PCT_INCREASE                                               VARCHAR2(40)
 DEF_FREELISTS                             NOT NULL        NUMBER
 DEF_FREELIST_GROUPS             NOT NULL        NUMBER
 DEF_LOGGING                                                            VARCHAR2(7)
 DEF_BUFFER_POOL                                                  VARCHAR2(7)
 DEF_PARAMETERS                                                  VARCHAR2(1000)
 INTERVAL                                                                  VARCHAR2(1000)