Purpose
The USER_TAB_SUBPARTITIONS view displays, for each table subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage attributes.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
ALL_TAB_SUBPARTITIONS
DBA_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 its value is NULL by default. |
| PCT_USED | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MIN_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and its value 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 its value is NULL by default. |
| BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and its value is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| INDEXING | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| READ_ONLY | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| INMEMORY | VARCHAR2(8) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| CELLMEMORY | VARCHAR2(24) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |