Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the information about the partitions, partitioning parameters, and partition statistics that the current user has access to.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_OWNER | varchar(128) | NO | The user who owns the partitioned table. |
| TABLE_NAME | varchar(128) | NO | The name of the partitioned table. |
| COMPOSITE | varchar(3) | NO | Whether the table is a composite partitioned table. |
| PARTITION_NAME | varchar(128) | NO | The name of the partition. |
| SUBPARTITION_COUNT | bigint(20) | NO | The number of subpartitions. |
| HIGH_VALUE | mediumtext | NO | The partitioning expression. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The length of the partitioning expression. |
| PARTITION_POSITION | bigint(20) | NO | The position of the partition. |
| TABLESPACE_NAME | varchar(30) | NO | The name of the tablespace to which the partition belongs. |
| PCT_FREE | bigint(0) | NO | This column is not supported. The default value is NULL. |
| PCT_USED | bigint(0) | NO | This column is not supported. The default value is NULL. |
| INI_TRANS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| MAX_TRANS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| INITIAL_EXTENT | bigint(0) | NO | This column is not supported. The default value is NULL. |
| NEXT_EXTENT | bigint(0) | NO | This column is not supported. The default value is NULL. |
| MIN_EXTENT | bigint(0) | NO | This column is not supported. The default value is NULL. |
| MAX_EXTENT | bigint(0) | NO | This column is not supported. The default value is NULL. |
| MAX_SIZE | bigint(0) | NO | This column is not supported. The default value is NULL. |
| PCT_INCREASE | bigint(0) | NO | This column is not supported. The default value is NULL. |
| FREELISTS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| FREELIST_GROUPS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| LOGGING | varchar(7) | NO | This column is not supported. The default value is NULL. |
| COMPRESSION | varchar(8) | NO | Whether to enable compression. |
| COMPRESS_FOR | varchar(30) | NO | The compression method. |
| NUM_ROWS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| BLOCKS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| EMPTY_BLOCKS | bigint(0) | NO | This column is not supported. The default value is NULL. |
| AVG_SPACE | bigint(0) | NO | This column is not supported. The default value is NULL. |
| CHAIN_CNT | bigint(0) | NO | This column is not supported. The default value is NULL. |
| AVG_ROW_LEN | bigint(0) | NO | This column is not supported. The default value is NULL. |
| SAMPLE_SIZE | bigint(0) | NO | This column is not supported. The default value is NULL. |
| LAST_ANALYZED | date | NO | This column is not supported. The default value is NULL. |
| BUFFER_POOL | varchar(7) | NO | This column is not supported. The default value is NULL. |
| FLASH_CACHE | varchar(7) | NO | This column is not supported. The default value is NULL. |
| CELL_FLASH_CACHE | varchar(7) | NO | This column is not supported. The default value is NULL. |
| GLOBAL_STATS | varchar(3) | NO | This column is not supported. The default value is NULL. |
| USER_STATS | varchar(3) | NO | This column is not supported. The default value is NULL. |
| IS_NESTED | varchar(3) | NO | This column is not supported. The default value is NULL. |
| PARENT_TABLE_PARTITION | varchar(128) | NO | This column is not supported. The default value is NULL. |
| INTERVAL | varchar(3) | NO | This field is not supported. The default value is NO. |
| SEGMENT_CREATED | varchar(4) | NO | This column is not supported. The default value is NULL. |
| INDEXING | varchar(4) | NO | This column is not supported. The default value is NULL. |
| READ_ONLY | varchar(4) | NO | This column is not supported. The default value is NULL. |
| INMEMORY | varchar(8) | NO | This column is not supported. The default value is NULL. |
| INMEMORY_PRIORITY | varchar(8) | NO | This column is not supported. The default value is NULL. |
| INMEMORY_DISTRIBUTE | varchar(15) | NO | This column is not supported. The default value is NULL. |
| INMEMORY_COMPRESSION | varchar(17) | NO | This column is not supported. The default value is NULL. |
| INMEMORY_DUPLICATE | varchar(13) | NO | This column is not supported. The default value is NULL. |
| CELLMEMORY | varchar(24) | NO | This column is not supported. The default value is NULL. |
| INMEMORY_SERVICE | varchar(12) | NO | This column is not supported. The default value is NULL. |
| INMEMORY_SERVICE_NAME | varchar(100) | NO | This column is not supported. The default value is NULL. |
| MEMOPTIMIZE_READ | varchar(8) | NO | This column is not supported. The default value is NULL. |
| MEMOPTIMIZE_WRITE | varchar(8) | NO | This column is not supported. The default value is NULL. |