Purpose
The ALL_TAB_SUBPARTITIONS view displays partition-level partitioning information, partition storage parameters, and partition statistics generated by the DBMS_STATS package for the partitions accessible to 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_SUBPARTITIONS
USER_TAB_SUBPARTITIONS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the table. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| HIGH_VALUE | VARCHAR2(32767) | NO | The subpartition expression. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the subpartition expression. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition. |
| SUBPARTITION_POSITION | NUMBER | NO | The position of the subpartition within the partition. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the subpartition. |
| PCT_FREE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| PCT_USED | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MIN_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MAX_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled for the subpartition. |
| COMPRESS_FOR | VARCHAR2(30) | YES | The compression method. |
| NUM_ROWS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| INDEXING | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| READ_ONLY | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | At present, this column is not supported and is NULL by default. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| CELLMEMORY | VARCHAR2(24) | NO | At present, this column is not supported and is NULL by default. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |