Note
This view has been available since V2.2.77.
Displays partition information for partitions accessible to the current user. The ALL_PART_INDEXES view displays the partitioning information of all partitioned indexes accessible to the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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 local or global. Valid values: LOCAL and GLOBAL. |
| ALIGNMENT | VARCHAR2(12) | NO | Indicates whether the partitioned index is prefixed or non-prefixed. Valid values: PREFIXED and 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 its value is 0 by default. |
| DEF_INI_TRANS | NUMBER | NO | At present, this column is not supported and its value is 0 by default. |
| DEF_MAX_TRANS | NUMBER | NO | At present, this column is not supported and its value is 0 by default. |
| DEF_INITIAL_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_NEXT_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_MIN_EXTENTS | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_MAX_EXTENTS | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_MAX_SIZE | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_PCT_INCREASE | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_FREELISTS | NUMBER | NO | At present, this column is not supported and its value is 0 by default. |
| DEF_FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is 0 by default. |
| DEF_LOGGING | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_PARAMETERS | VARCHAR2(1000) | NO | At present, this column is not supported and its value is NULL by default. |
| INTERVAL | VARCHAR2(1000) | NO | At present, this column is not supported and its value is NO 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 its value is NULL by default. |
| AUTOLIST_SUBPARTITION | VARCHAR2(1000) | NO | At present, this column is not supported and its value is NULL by default. |
Sample query
Query the partition information of the partitioned index TBL1_H_IDX1 that is accessible to the current user.
obclient [SYS]> SELECT * FROM SYS.ALL_PART_INDEXES WHERE INDEX_NAME='TBL1_H_IDX1'\G
The query result is as follows:
*************************** 1. row ***************************
OWNER: SYS
INDEX_NAME: TBL1_H_IDX1
TABLE_NAME: TBL1_H
PARTITIONING_TYPE: RANGE
SUBPARTITIONING_TYPE: NONE
PARTITION_COUNT: 3
DEF_SUBPARTITION_COUNT: 0
PARTITIONING_KEY_COUNT: 1
SUBPARTITIONING_KEY_COUNT: 0
LOCALITY: GLOBAL
ALIGNMENT: PREFIXED
DEF_TABLESPACE_NAME: NULL
DEF_PCT_FREE: 0
DEF_INI_TRANS: 0
DEF_MAX_TRANS: 0
DEF_INITIAL_EXTENT: NULL
DEF_NEXT_EXTENT: NULL
DEF_MIN_EXTENTS: NULL
DEF_MAX_EXTENTS: NULL
DEF_MAX_SIZE: NULL
DEF_PCT_INCREASE: NULL
DEF_FREELISTS: 0
DEF_FREELIST_GROUPS: 0
DEF_LOGGING: NULL
DEF_BUFFER_POOL: NULL
DEF_FLASH_CACHE: NULL
DEF_CELL_FLASH_CACHE: NULL
DEF_PARAMETERS: NULL
INTERVAL: NO
AUTOLIST: NO
INTERVAL_SUBPARTITION: NULL
AUTOLIST_SUBPARTITION: NULL
1 row in set