Purpose
The ALL_PART_TABLES view 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
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 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 column 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 column is not supported and is NULL by default. |
| DEF_PCT_USED | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_INI_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_MAX_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_INITIAL_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_NEXT_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_MIN_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| MAX_EXTENT | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_MAX_SIZE | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_PCT_INCREASE | VARCHAR2(40) | NO | At present, this column is not supported and is NULL by default. |
| DEF_FREELISTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEF_LOGGING | VARCHAR2(7) | NO | At present, this column 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 column is not supported and is NULL by default. |
| DEF_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| DEF_CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| REF_PTN_CONSTRAINT_NAME | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| AUTOLIST | VARCHAR2(3) | NO | Indicates whether the local index is automatic list-partitioned. Valid values: |
| INTERVAL_SUBPARTITION | VARCHAR2(1000) | NO | At present, this column is not supported and is NULL by default. |
| AUTOLIST_SUBPARTITION | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| IS_NESTED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DEF_SEGMENT_CREATED | VARCHAR2(4) | NO | At present, this column is not supported and 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 | The default value is NULL and has no practical meaning. |
| DEF_INMEMORY_PRIORITY | VARCHAR2(8) | NO | The default value is NULL and has no practical meaning. |
| DEF_INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | The default value is NULL and has no practical meaning. |
| DEF_INMEMORY_COMPRESSION | VARCHAR2(17) | NO | The default value is NULL and has no practical meaning. |
| DEF_INMEMORY_DUPLICATE | VARCHAR2(13) | NO | The default value is NULL and has no practical meaning. |
| DEF_READ_ONLY | VARCHAR2(3) | NO | The default settings for new partitions. Valid values:YES: The new partitions are read-only by default.NO: The new partitions are read/write by default. |
| DEF_CELLMEMORY | VARCHAR2(24) | NO | The default value is NULL and has no practical meaning. |
| DEF_INMEMORY_SERVICE | VARCHAR2(12) | NO | The default value is NULL and has no practical meaning. |
| DEF_INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | The default value is NULL and has no practical meaning. |
| AUTO | VARCHAR2(3) | NO | Indicates whether the table is partitioned automatically. Valid values: |