ALL_PART_INDEXES

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

Related Views

• DBA_PART_INDEXES provides such information for all partitioned indexes in the database.

• USER_PART_INDEXES provides such information for all 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 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
  DEF_PARAMETERS	VARCHAR2(1000)