Purpose
The ALL_PART_INDEXES view displays the partitioning information about all partitioned indexes accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
DBA_PART_INDEXESUSER_PART_INDEXES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the partitioned index. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the partitioned index. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table containing the index. |
| PARTITIONING_TYPE | VARCHAR2(9) | NO | The partitioning method. Valid values: |
| SUBPARTITIONING_TYPE | VARCHAR2(9) | NO | The subpartitioning method. Valid values: |
| PARTITION_COUNT | NUMBER | NO | The number of partitions in the index. |
| DEF_SUBPARTITION_COUNT | NUMBER | NO | The default number of subpartitions for a composite-partitioned index. |
| PARTITIONING_KEY_COUNT | NUMBER | NO | The number of partitioning keys. |
| SUBPARTITIONING_KEY_COUNT | NUMBER | NO | The number of subpartitioning keys for a composite-partitioned index. |
| LOCALITY | VARCHAR2(6) | NO | Indicates whether the partitioned index is a local index (LOCAL) or a global index (GLOBAL). |
| ALIGNMENT | VARCHAR2(12) | NO | Indicates whether the partitioned index is prefixed or non-prefixed. |
| DEF_TABLESPACE_NAME | VARCHAR2(30) | NO | The default tablespace for a local index when a table partition is added or split. |
| DEF_PCT_FREE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_INI_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_MAX_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_INITIAL_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_NEXT_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_MIN_EXTENTS | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_MAX_EXTENTS | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_MAX_SIZE | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_PCT_INCREASE | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_FREELISTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_LOGGING | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| DEF_BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| DEF_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| DEF_CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| DEF_PARAMETERS | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| AUTOLIST | VARCHAR2(3) | NO | Indicates whether the local index is partitioned through the automatic list. Valid values: |
| INTERVAL_SUBPARTITION | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| AUTOLIST_SUBPARTITION | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |