Feature
USER_TAB_PARTITIONS describes partition-level partitioning information, partition storage parameters, and partition statistics for all partitions owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_TAB_PARTITIONS
ALL_TAB_PARTITIONS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the partitioned table. |
| COMPOSITE | VARCHAR2(3) | NO | Indicates whether the partition is a composite partition. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_COUNT | NUMBER | YES | The number of subpartitions. |
| HIGH_VALUE | VARCHAR2(32767) | NO | The partition expression. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the partition expression. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the partition. |
| PCT_FREE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| PCT_USED | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MIN_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MAX_EXTENT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| LOGGING | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled. |
| COMPRESS_FOR | VARCHAR2(30) | YES | The compression method. |
| NUM_ROWS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| BLOCKS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this field is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| IS_NESTED | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| PARENT_TABLE_PARTITION | VARCHAR2(128) | NO | At present, this field is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(4) | NO | At present, this field is not supported and is NULL by default. |
| INDEXING | VARCHAR2(4) | NO | The index attribute. Valid values: |
| READ_ONLY | VARCHAR2(4) | NO | Indicates whether the subpartition is read-only. Valid values: |
| INMEMORY | VARCHAR2(8) | NO | Indicates whether in-memory column store is enabled for the subpartition. Valid values: |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | The padding priority of the in-memory column store. Valid values: |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | At present, this field is not supported and is NULL by default. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | The compression level for in-memory column store. Valid values: This value is based on the location of the middle section of the table. For example, if the table is partitioned and in-memory column store is enabled, the value of ALL_TABLES is NULL, and the value of ALL_TAB_SUBPARTITIONS is not NULL. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | At present, this field is not supported and is NULL by default. |
| CELLMEMORY | VARCHAR2(24) | NO | At present, this field is not supported and is NULL by default. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | The way that in-memory column store is padded on various instances. Valid values: |
| INMEMORY_SERVICE_NAME | VARCHAR2(100) | NO | The name of the service on which in-memory column store is padded. This column has values only when INMEMORY_SERVICE is set to USER_DEFINED. It is empty in other cases. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | Indicates whether shortcut-based access is enabled for the table. Valid values: |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | For internal use only. |