Feature
USER_PART_TABLES displays the partitioning information about the partitioned tables owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_PART_TABLESDBA_PART_TABLES
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| 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 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 padding priority of the 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 name of the service on which in-memory column store is padded. This column has values only when DEF_INMEMORY_SERVICE is set to USER_DEFINED. It is empty in other cases. |
| AUTO | VARCHAR2(3) | NO | Indicates whether the table is partitioned automatically. Valid values: |