Purpose
The ALL_TAB_PARTITIONS view displays the multi-level partitioning information, partition storage parameters, and partition statistics of all partitioned tables.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
DBA_TAB_PARTITIONS
USER_TAB_PARTITIONS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the partitioned table. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the partitioned table. |
| COMPOSITE | VARCHAR2(3) | NO | Indicates whether the table is composite-partitioned. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_COUNT | NUMBER | NO | The number of subpartitions. |
| 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. |
| 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. |
| PCT_USED | 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(8) | NO | Indicates whether compression is enabled. |
| COMPRESS_FOR | VARCHAR2(30) | NO | The compression method. |
| NUM_ROWS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_ROW_LEN | 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. |
| GLOBAL_STATS | VARCHAR2(3) | 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. |
| IS_NESTED | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| PARENT_TABLE_PARTITION | VARCHAR2(128) | 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(4) | NO | At present, this column is not supported and its value is NULL by default. |
| INDEXING | VARCHAR2(4) | NO | At present, this column is not supported and its value is NULL by default. |
| READ_ONLY | VARCHAR2(4) | NO | At present, this column is not supported and its value is NULL by default. |
| INMEMORY | VARCHAR2(8) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | At present, this column is not supported and its value is NULL by default. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| CELLMEMORY | VARCHAR2(24) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_SERVICE_NAME | VARCHAR2(100) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |