Feature
ALL_PART_TABLES displays the partitioning information of all partitioned tables 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_PART_TABLES
USER_PART_TABLES
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the partitioned table. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the partitioned table. |
| PARTITIONING_TYPE | VARCHAR2(9) | NO | The partitioning method. Valid values: |
| SUBPARTITIONING_TYPE | VARCHAR2(9) | NO | The subpartitioning method. Valid values: |
| PARTITION_COUNT | NUMBER | NO | The number of partitions in the partitioned table. |
| DEF_SUBPARTITION_COUNT | NUMBER | NO | The default number of subpartitions for a composite-partitioned table. |
| PARTITIONING_KEY_COUNT | NUMBER | NO | The number of partitioning keys. |
| SUBPARTITIONING_KEY_COUNT | NUMBER | NO | The number of subpartitioning keys for a composite-partitioned table. |
| STATUS | VARCHAR2(8) | NO | At present, this field is not supported and is NULL by default. |
| DEF_TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the partitioned table. |
| DEF_PCT_FREE | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| DEF_PCT_USED | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| DEF_INI_TRANS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| DEF_MAX_TRANS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| DEF_INITIAL_EXTENT | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| DEF_NEXT_EXTENT | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| DEF_MIN_EXTENT | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| MAX_EXTENT | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| DEF_MAX_SIZE | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| DEF_PCT_INCREASE | VARCHAR2(40) | NO | At present, this field is not supported and is NULL by default. |
| DEF_FREELISTS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| DEF_FREELIST_GROUPS | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| DEF_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) | NO | The compression method. |
| DEF_BUFFER_POOL | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| DEF_FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| DEF_CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this field is not supported and is NULL by default. |
| REF_PTN_CONSTRAINT_NAME | VARCHAR2(128) | NO | At present, this field is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(1000) | NO | At present, this field is not supported and is NULL by default. |
| AUTOLIST | VARCHAR2(3) | NO | Indicates whether the local index is partitioned through the automatic list. Valid values: |
| INTERVAL_SUBPARTITION | VARCHAR2(1000) | NO | At present, this field is not supported and is NULL by default. |
| AUTOLIST_SUBPARTITION | 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. |
| DEF_SEGMENT_CREATED | VARCHAR2(4) | NO | At present, this field is not supported and is NULL by default. |
| DEF_INDEXING | VARCHAR2(3) | NO | The index attribute specified for the table. Valid values: |
| DEF_INMEMORY | VARCHAR2(8) | NO | Indicates whether in-memory column store is used for partitions in the table. Valid values: |
| DEF_INMEMORY_PRIORITY | VARCHAR2(8) | NO | The default priority padded by in-memory column store. Valid values: |
| DEF_INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | At present, this field is not supported and is NULL by default. |
| DEF_INMEMORY_COMPRESSION | VARCHAR2(17) | NO | The default compression level for in-memory column store. Valid values: |
| DEF_INMEMORY_DUPLICATE | VARCHAR2(13) | NO | At present, this field is not supported and is NULL by default. |
| DEF_READ_ONLY | VARCHAR2(3) | NO | The default settings for new partitions. Valid values: |
| DEF_CELLMEMORY | VARCHAR2(24) | NO | Indicates that new partitions in the parent table will inherit the default value of the CELLMEMORY property unless it is explicitly overridden. |
| DEF_INMEMORY_SERVICE | VARCHAR2(12) | NO | The way that in-memory column store is padded by default for table partitioning on various instances. Valid values: |
| DEF_INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | The way that in-memory column store is padded by default for table partitioning on various instances. Valid values: |
| AUTO | VARCHAR2(3) | NO | Indicates whether the table is partitioned automatically. Valid values: |