ALL_PART_INDEXES
displays the object-level partitioning information for the partitioned indexes accessible to the current user.
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:
|
|
SUBPARTITIONING_TYPE |
VARCHAR2(7) |
Type of composite partitioning method:
|
|
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 |
See Also: