ALL_PART_INDEXES

ALL_PART_INDEXES displays the object-level partitioning information for the partitioned indexes accessible to the current user.

Related Views

DBA_PART_INDEXES displays the object-level partitioning information for all partitioned indexes in the database.
USER_PART_INDEXES displays the object-level partitioning information for the partitioned indexes owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`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)`		Type of partitioning method: `RANGE` `HASH` `SYSTEM` `LIST`
`SUBPARTITIONING_TYPE`	`VARCHAR2(7)`		Type of composite partitioning method: `NONE` `HASH` `SYSTEM` `LIST`
`PARTITION_COUNT`	`NUMBER`	`NOT NULL`	Number of partitions in the index
`DEF_SUBPARTITION_COUNT`	`NUMBER`		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`		For a composite-partitioned index, the number of columns in the subpartitioning key
`LOCALITY`	`VARCHAR2(6)`		Indicates whether the partitioned index is local (`LOCAL`) or global (`GLOBAL`)
`ALIGNMENT`	`VARCHAR2(12)`		Indicates whether the 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 (in Oracle blocks) 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` (in Oracle blocks), 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