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 the MySQL mode.
Related views
DBA_PART_TABLESUSER_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 partitioned through the automatic list. 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 | Indicates whether in-memory column store is used for partitions in the table. Valid values:ENABLED: In-memory column store is enabled. This is the default value.DISABLED: In-memory column store is disabled.NONE: The parameter is not specified. |
| 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 column 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 column is not supported and is NULL by default. |
| 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 | Indicates that new partitions in the parent table will inherit the default value of the CELLMEMORY attribute 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:DEFAULTPARALLEL_INSTANCE_GROUP: Data is padded on all instances specified by the initialization parameter. This is the default value. If this parameter is not set, data is padded for all instances.NONE: Data is not padded for any instance.ALL: Data is padded for all instances regardless of the settings of the initialization parameter PARALLEL_INSTANCE_GROUP.USER_DEFINED: Data is padded only for instances where the user-defined service is active. The service name is saved in the DEF_INMEMORY_SERVICE_NAME column. |
| 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:DEFAULTPARALLEL_INSTANCE_GROUP: Data is padded on all instances specified by the initialization parameter. This is the default value. If this parameter is not set, data is padded for all instances.NONE: Data is not padded for any instance.ALL: Data is padded for all instances regardless of the settings of the initialization parameter PARALLEL_INSTANCE_GROUP.USER_DEFINED: Data is padded only for instances where the user-defined service is active. The service name is saved in the DEF_INMEMORY_SERVICE_NAME column. |
| AUTO | VARCHAR2(3) | NO | Indicates whether the table is partitioned automatically. Valid values: |