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 the partitioning method:
|
|
SUBPARTITIONING_TYPE |
VARCHAR2(7) |
Type of the 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 (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:
|
|
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 | |
INTERVAL |
VARCHAR2(1000) |
String of the interval value |
See Also: