Purpose
The USER_PART_TABLES view 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 the MySQL mode.
Related views
ALL_PART_TABLESDBA_PART_TABLES
Columns
| Column | 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 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 | The default way that in-memory column store is allocated to partitions of the table in a Real Application Clusters (RAC) environment. Valid values: |
| DEF_INMEMORY_COMPRESSION | VARCHAR2(17) | NO | The default compression level for in-memory column store. Valid values: |
| DEF_INMEMORY_DUPLICATE | VARCHAR2(13) | NO | The default duplicate settings for in-memory column store in the RAC environment. Valid values: |
| 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 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: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: |