Purpose
The USER_TAB_SUBPARTITIONS view displays, for each subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage properties.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_TAB_SUBPARTITIONSDBA_TAB_SUBPARTITIONS
Columns
| Column | Type | Nullable? | Description | ||
|---|---|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. | ||
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. | ||
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. | ||
| HIGH_VALUE | VARCHAR2(32767) | NO | The subpartition expression. | ||
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the subpartition expression. | ||
| PARTITION_POSITION | NUMBER | NO | The position of the partition. | ||
| SUBPARTITION_POSITION | NUMBER | NO | The position of the subpartition within the partition. | ||
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace containing the subpartition. | ||
| PCT_FREE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| PCT_USED | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| INI_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| MAX_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| MIN_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| MAX_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| MAX_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| FREELISTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
||
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled for the subpartition. | ||
| COMPRESS_FOR | VARCHAR2(30) | YES | The compression method. | ||
| NUM_ROWS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| EMPTY_BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| AVG_SPACE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| CHAIN_CNT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| AVG_ROW_LEN | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
||
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and is NULL by default. |
||
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
||
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
||
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
||
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
||
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
||
| INTERVAL | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
||
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
||
| INDEXING | VARCHAR2(3) | NO | The index attribute. Valid values:ON: The index of the subpartition is enabled.OFF: The index of the subpartition is disabled. |
||
| READ_ONLY | VARCHAR2(3) | NO | Indicates whether the subpartition is read-only. Valid values:YES: The subpartition is read-only.NO: The subpartition can be read and written. |
||
| INMEMORY | VARCHAR2(8) | NO | Indicates whether in-memory column store is enabled for the subpartition. Valid values:ENABLED: In-memory column store is enabled.DISABLED: In-memory column store is disabled. |
||
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | The padding priority of the in-memory column store. Valid values: |
||
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | The distribution of in-memory column store in a Real Application Clusters (RAC) environment. Valid values: |
||
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | The compression level for in-memory column store. Valid values: |
HIGH ] |
HIGH ] This value is based on the location of the middle section of the table. For example, if the table is partitioned and in-memory column store is enabled, the value for ALL_TABLES is NULL and the value for ALL_TAB_SUBPARTITIONS is not NULL. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | The duplicate settings for in-memory column store in the RAC environment. Valid values: |
||
| INMEMORY_SERVICE | VARCHAR2(12) | NO | The way that in-memory column store is padded 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 INMEMORY_SERVICE_NAME column. |
||
| 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 INMEMORY_SERVICE is set to USER_DEFINED, and is empty in other cases. |
||
| CELLMEMORY | VARCHAR2(24) | NO | The column compression value in the flash cache of the storage unit. Valid values:ENABLED: Exadata Storage will automatically determine whether to cache data as a column.DISABLED: Exadata Storage is prevented from caching data as a column.NO CACHECOMPRESS: Exadata Storage will cache data in HCC format (where no re-compression is required).FOR QUERY: Exadata Storage will recompress and cache data in high INMEMORY query format.FOR CAPACITY: Exadata Storage will recompress and cache data in low INMEMORY capacity format. This column is mainly used with Exadata. |
||
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | Indicates whether shortcut-based access is enabled for the table. Valid values: |
||
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | For internal use only. |