Purpose
The ALL_PART_TABLES view displays the partitioning information of all partitioned tables accessible to the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | 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 if the table is a composite-partitioned table. |
| PARTITIONING_KEY_COUNT | NUMBER | NO | The number of partitioning keys. |
| SUBPARTITIONING_KEY_COUNT | NUMBER | NO | The number of subpartitioning keys if the table is a composite-partitioned table. |
| STATUS | VARCHAR2(8) | NO | At present, this column is not supported and its value 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 column is not supported and its value is NULL by default. |
| DEF_PCT_USED | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_INI_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_MAX_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_INITIAL_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_NEXT_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_MIN_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_MAX_SIZE | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_PCT_INCREASE | VARCHAR2(40) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_FREELISTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_LOGGING | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled. |
| DEF_COMPRESS_FOR | VARCHAR2(30) | NO | The compression method. |
| DEF_BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| REF_PTN_CONSTRAINT_NAME | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default. |
| INTERVAL | VARCHAR2(1000) | NO | At present, this column is not supported and its value 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 column is not supported and its value is NULL by default. |
| AUTOLIST_SUBPARTITION | 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. |
| DEF_SEGMENT_CREATED | VARCHAR2(4) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_INDEXING | VARCHAR2(3) | NO | The index attribute specified for the table. Valid values: ON-INDEXING: ON is explicitly specified, or the index attribute is not specified.OFF-INDEXING: The index attribute is disabled. |
| DEF_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. |
| DEF_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. |
| DEF_INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| DEF_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. |
| DEF_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. |
| DEF_READ_ONLY | VARCHAR2(3) | NO | The default settings for new partitions. Valid values: YES: New partitions are read-only.NO: Read/write operations are supported for new partitions. |
| DEF_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. |
| DEF_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. |
| DEF_INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| AUTO | VARCHAR2(3) | NO | Indicates whether the table is partitioned automatically. Valid values: |
References
DBA_PART_TABLES
USER_PART_TABLES