Purpose
The ALL_IND_PARTITIONS view displays the information about index partitions accessible to the current user in the database.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
DBA_IND_PARTITIONS
USER_IND_PARTITIONS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| INDEX_OWNER | VARCHAR2(128) | NO | The owner of the index. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| COMPOSITE | VARCHAR2(3) | NO | Indicates whether the partition belongs to the local index of the composite-partitioned table. Valid values: |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_COUNT | NUMBER | NO | The number of subpartitions. |
| HIGH_VALUE | VARCHAR2(32767) | NO | The expression for the value bound to the partition. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the expression for the value bound to the partition. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition within the index. |
| STATUS | VARCHAR2(8) | NO | Indicates whether the index partition is usable. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the partition. |
| PCT_FREE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MIN_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LOGGING | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| COMPRESSION | VARCHAR2(13) | NO | Indicates whether compression is enabled for the partitioned index. Valid values: |
| BLEVEL | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NUM_ROWS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and its value is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_DIRECT_ACCESS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | At present, this column is not supported and its value is NULL by default. |
| PARAMETERS | VARCHAR2(1000) | NO | At present, this column is not supported and its value is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | At present, this column is not supported and its value is NO by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| ORPHANED_ENTRIES | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |