Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_PART_INDEXES

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

Related Views

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