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(9)   Type of the partitioning method:
  • NONE - Not specified

    See Also: the *_INDEXES view

  • RANGE

  • HASH

  • SYSTEM

  • LIST

  • REFERENCE

SUBPARTITIONING_TYPE VARCHAR2(9)   Type of the composite partitioning method:
  • NONE - Not specified

    See Also: the *_INDEXES view

  • RANGE

  • HASH

  • SYSTEM

  • LIST

  • REFERENCE

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 (PREFIXED) or non-prefixed (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 value to be used when adding a table partition
DEF_MAX_TRANS NUMBER NOT NULL For a local index, the default MAXTRANS value to be used when adding a table partition
DEF_INITIAL_EXTENT VARCHAR2(40)   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)   For a local index, the default NEXT value (in Oracle blocks) to be used when adding a table partition, or DEFAULT if no NEXT value was specified
DEF_MIN_EXTENTS VARCHAR2(40)   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)   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_MAX_SIZE VARCHAR2(40)   For a local index, the default MAXSIZE value to be used when adding a table partition, or DEFAULT if no MAXSIZE value was specified
DEF_PCT_INCREASE VARCHAR2(40)   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
DEF_FREELIST_GROUPS NUMBER NOT NULL For a local index, the default FREELIST GROUPS value to be used when adding a table partition
DEF_LOGGING VARCHAR2(7)   For a local index, the default LOGGING attribute to be used when adding a table partition:
  • NONE - Not specified

    See Also: the *_INDEXES view

  • YES

  • NO

DEF_BUFFER_POOL VARCHAR2(7)   For a local index, the default buffer pool to be used when adding a table partition:
  • DEFAULT

  • KEEP

  • RECYCLE

  • NULL

DEF_FLASH_CACHE VARCHAR2(7)   For a local index, the default Database Smart Flash Cache hint to be used when adding a table partition:
  • DEFAULT

  • KEEP

  • NONE

Solaris and Oracle Linux functionality only.

DEF_CELL_FLASH_CACHE VARCHAR2(7)   For a local index, the default cell flash cache hint to be used when adding a table partition:
  • DEFAULT

  • KEEP

  • NONE

See Also: Oracle Exadata Storage Server Software documentation for more information

DEF_PARAMETERS VARCHAR2(1000)   Default parameter string for domain indexes
INTERVAL VARCHAR2(1000)   String of the interval value